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 strongm 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
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...- ParikhV
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
SSO Role with 'add user' privilege
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?- ParikhV
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
