Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • Last Modified:

sybase, how to grant certain system procedure to user

application team have requested me to allow a following permission to one of the user, actually how do we execute selective procedure below to be able to run by users ? I think sso_role will help me but again application team want something limited with sso-role ( not all permission within sso-role )

sso_role (default ON) - what is inside default ? and how do I grant only limited sso_role privileges ?


sp_addlogin_ sp_password_ sp_kill_ sp_unlocklogin_ sp_locklogin_ sp_displaylogin
0
motioneye
Asked:
motioneye
1 Solution
 
Jan FranekCommented:
There's the technique allowing selective access to functions requiring sa (or sso) role using CIS. Very good description is at http://www.sypron.nl/grant_sa.html
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now