# user access

**URL:** <https://forum.kx.com/t/user-access/6707>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [August 27, 2010, 12:55pm UTC](https://forum.kx.com/t/user-access/6707 "2010-08-27T12:55:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![will2](https://avatars.discourse-cdn.com/v4/letter/w/a587f6/32.png) [@will2](https://forum.kx.com/u/will2)\
**Post date:** [August 27, 2010, 12:55pm UTC](https://forum.kx.com/t/user-access/6707/1 "2010-08-27T12:55:00Z")

</div>

Hi,Using command line parameters -s 2 -w 2000 -T 300but also added -b , to make database read only. I now get 'noupdateerror. Any way to undo this command?Can I ask also how is authentication used in Studio. eg Auth.MethUsername and password, but error "An error occurred during executionof the query.The server sent the response:Authentication failed"Thank you.Rgds,Will

---

<div class="post-metadata">

**Author:** ![trieder](https://avatars.discourse-cdn.com/v4/letter/t/a587f6/32.png) [@trieder](https://forum.kx.com/u/trieder)\
**Post date:** [August 27, 2010, 1:16pm UTC](https://forum.kx.com/t/user-access/6707/2 "2010-08-27T13:16:00Z")

</div>

In-Reply-To: \<6dfd57a9-e703-4a34-8f1f-611e5c899990@x24g2000pro.googlegroups.com\>  
Message-Id: \<1A3C75E0-D1F0-494A-9007-B54FA9407093@gmail.com\>  
Date: Fri, 27 Aug 2010 08:16:14 -0400  
Cc: Kdb+ Personal Developers   
To: “[personal-kdbplus@googlegroups.com](mailto:personal-kdbplus@googlegroups.com)”   
Mime-Version: 1.0 (iPhone Mail 8A306)  
X-Mailer: iPhone Mail (8A306)  
  
-b and negative port makes the instance read only to all clients. If you wan=  
t to work around this you can:  
  
1) maybe use anon lambdas with locals if you need to create temp vars. This i=  
s the proper way to allow adhoc queries IMO anyway.  
  
2) override query callbacks (ie pg,ps,ph etc) and write your own mechanism. T=  
his is time consuming and complex unless you limit clients to canned queries=  
/functions.  
  
Studio for kdb uses the .z.pw callback and/or a password file. This is the s=  
ame method for all clients.

---

<div class="post-metadata">

**Author:** ![will2](https://avatars.discourse-cdn.com/v4/letter/w/a587f6/32.png) [@will2](https://forum.kx.com/u/will2)\
**Post date:** [August 27, 2010, 3:25pm UTC](https://forum.kx.com/t/user-access/6707/3 "2010-08-27T15:25:00Z")

</div>

thanks for the reply.sorry i’m a newbie :) …in the case of -b, I simply want to make theport readwrite again… or to how to remove the noupdate error..Thanks.Will.On Aug 27, 8:16?pm, Timothy Rieder \<trie…\> wrote:\> -b and negative port makes the instance read only to all clients. If you want to work around this you can:\>\> 1) maybe use anon lambdas with locals if you need to create temp vars. This is the proper way to allow adhoc queries IMO anyway.\>\> 2) override query callbacks (ie pg,ps,ph etc) and write your own mechanism. This is time consuming and complex unless you limit clients to canned queries/functions.\>\> Studio for kdb uses the .z.pw callback and/or a password file. This is the same method for all clients.\>\> On Aug 27, 2010, at 7:55 AM, will \<will.yeu…\> wrote:\>\>\>\> \> Hi,\>\> \> Using command line parameters ?-s 2 -w ?2000 -T 300\> \> but also added -b , to make database read only. I now get 'noupdate\> \> error. Any way to undo this command?\>\> \> Can I ask also how is authentication used in Studio. eg Auth.Meth\> \> Username and password, but error “An error occurred during execution\> \> of the query.\> \> The server sent the response:\> \> Authentication failed”\> \> Thank you.\> \> Rgds,\> \> Will\>\> \> –\> \>

Submitted via Google Groups\</will.yeu…\>\</trie…\>

---

<div class="post-metadata">

**Author:** ![simon11](https://avatars.discourse-cdn.com/v4/letter/s/7c8e57/32.png) [@simon11](https://forum.kx.com/u/simon11)\
**Post date:** [August 27, 2010, 3:48pm UTC](https://forum.kx.com/t/user-access/6707/4 "2010-08-27T15:48:00Z")

</div>

can’t do that, -b is a one-way ticket - that’s a security feature&nbsp;

---

<div class="post-metadata">

**Author:** ![will2](https://avatars.discourse-cdn.com/v4/letter/w/a587f6/32.png) [@will2](https://forum.kx.com/u/will2)\
**Post date:** [August 27, 2010, 4:05pm UTC](https://forum.kx.com/t/user-access/6707/5 "2010-08-27T16:05:00Z")

</div>

ok thanksOn Aug 27, 10:48?pm, Simon Garland \<si…\> wrote:\> can’t do that, -b is a one-way ticket - that’s a security feature\>\> On 27 August 2010 16:25, will \<will.yeu…\> wrote:\>\>\> ,\> \> thanks for the reply.\>\> \> sorry i’m a newbie :) …in the case of -b, I simply want to make the\> \> port readwrite again… or to how to remove the noupdate error..\>\> \> Thanks.\> \> Will.\>\> \> On Aug 27, 8:16 pm, Timothy Rieder \<trie…\> wrote:\> \> \> -b and negative port makes the instance read only to all clients. If you\> \> want to work around this you can:\>\> \> \> 1) maybe use anon lambdas with locals if you need to create temp vars.\> \> This is the proper way to allow adhoc queries IMO anyway.\>\> \> \> 2) override query callbacks (ie pg,ps,ph etc) and write your own\> \> mechanism. This is time consuming and complex unless you limit clients to\> \> canned queries/functions.\>\> \> \> Studio for kdb uses the .z.pw callback and/or a password file. This is\> \> the same method for all clients.\>\> \> \> On Aug 27, 2010, at 7:55 AM, will \<will.yeu…\> wrote:\>\> \> \> \> Hi,\>\> \> \> \> Using command line parameters ?-s 2 -w ?2000 -T 300\> \> \> \> but also added -b , to make database read only. I now get 'noupdate\> \> \> \> error. Any way to undo this command?\>\> \> \> \> Can I ask also how is authentication used in Studio. eg Auth.Meth\> \> \> \> Username and password, but error “An error occurred during execution\> \> \> \> of the query.\> \> \> \> The server sent the response:\> \> \> \> Authentication failed”\> \> \> \> Thank you.\> \> \> \> Rgds,\> \> \> \> Will\>\> \> \> \> –\> \> \> \> You received this message because you are subscribed to the Google\> \> Groups “Kdb+ Personal Developers” group.\> \> \> \> To post to this group, send email to [personal-kdbplus@googlegroups.com](mailto:personal-kdbplus@googlegroups.com)\> \> .\> \> \> \> To unsubscribe from this group, send email to\> \> [personal-kdbplus+unsubscribe@googlegroups.com](mailto:personal-kdbplus+unsubscribe@googlegroups.com)\> \> .\> \> \> \> For more options, visit this group athttp://\> \> [groups.google.com/group/personal-kdbplus?hl=en.-](http://groups.google.com/group/personal-kdbplus?hl=en.-) Hide quoted text -\>\> \> \> - Show quoted text -\>\> \> –\> \>

Submitted via Google Groups\</will.yeu…\>\</trie…\>\</will.yeu…\>\</si…\>
