As you might know the SSO role will allow management of server login ids but will not allow management of database users that requires 'dbo' role. What is a best way to define a server id that has System Security Officer (SSO) role with ability to manage database users?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SSO Role with 'add user' privilege
- Thread starter ParikhV
- Start date
- Thread starter
- #2
I got the answer from SYBASE that this is a bug in their system stored procedures mainly sp_adduser, sp_dropuser and sp_modifylogin that does not check for sso_role in 11.0.3.3 release. I created my own copy of these procs under new names and modified the code to allow sso_role and that seem to work fine. Sybase did mention that these problems are fixed in 11.5 + releases.
- Status
Similar threads
- Locked
- Question
- Locked
- Question