Solved

sybase, how to grant certain system procedure to user

Posted on 2013-06-18
1
609 Views
Last Modified: 2013-06-20
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
Comment
Question by:motioneye
1 Comment
 
LVL 14

Accepted Solution

by:
Jan_Franek earned 500 total points
ID: 39258593
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

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
truncation error - math operation 6 562
Sybase ASE 15.7 do not know datepart function 2 1,216
Sybase Customized sp_thresholdaction 2 667
sybase output only middle rows 4 24
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
This problem is more common than not and I will show you some things to check to solve this problem.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question