Ad-hoc updates to system catalogs not enabled

[L_Kwan]

Cannot add a new user in a database..

1> use ARSystem
2> go
1> sp_configure "allow updates", 1
2> go
Parameter Name Default Memory Used Config Value
Run Value
------------------------------ ----------- ----------- ------------
-----------
allow updates to system tables 0 0 1
1

(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
(return status = 0)
1>
2> sp_adduser login_read1, a_name
3> go
Msg 10321, Level 14, State 1:
Procedure 'sp_adduser', Line 299:
Ad-hoc updates to system catalogs not enabled. A user with System Security
Officer (SSO) role must reconfigure system to allow this.
(return status = -4)
1> sp_configure "allow updates", 0

Please reply to l_k...@canada.com if you have any hint.

Thanks in advance.
LKwan

[Jim Egan]

L_Kwan wrote...

Rerun the installmaster script. That should do it.
--
Jim Egan [TeamSybase]

[Bret Halford]

To add a bit of explanation: for stored procedures, the current setting
of "allow updates"
does not matter. What matters is whether that option was turned on at
the time the procedure
was created. Instead of running the entire installmaster script, you
could just
extract the script for sp_adduser with defncopy, turn the option on (you
already have),
and run the script. However, if you have multiple procedures somehow
suffering from this,
running the installmaster script will be easier.

-bret