|
Home > Archive > MS SQL Server > July 2005 > Need to enable access to delete sysuser
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need to enable access to delete sysuser
|
|
|
| I am trying to delete a user in sysuser and am getting a message that says
ad hoc updates to systems catalog are not enabled, how do you enable the
ability to update?
| |
| Narayana Vyas Kondreddi 2005-07-20, 1:23 pm |
| Why are you deleting directly from the system tables? If you want to drop a
user from a database, use sp_revokedbaccess. See SQL Server Books Online for
more information.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"sd" <susan.dunn@ncsl.org> wrote in message
news:eJSYpVVjFHA.1968@TK2MSFTNGP14.phx.gbl...
>I am trying to delete a user in sysuser and am getting a message that says
> ad hoc updates to systems catalog are not enabled, how do you enable the
> ability to update?
>
>
| |
| Narayana Vyas Kondreddi 2005-07-21, 9:23 am |
| If you are talking about orphan users, then use sp_change_users_logi
n. See
http://vyaskn.tripod.com/ troublesh.../>
an_users.htm for more
information.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"sd" <susan.dunn@ncsl.org> wrote in message
news:eJSYpVVjFHA.1968@TK2MSFTNGP14.phx.gbl...
I am trying to delete a user in sysuser and am getting a message that says
ad hoc updates to systems catalog are not enabled, how do you enable the
ability to update?
|
|
|
|
|