Solved

sybase, how to grant certain system procedure to user

Posted on 2013-06-18
1
629 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
The goal of this blog is to: > note what has impeded us from reaching effective life on-call > provide 3 steps to mastering life on-call > highlight what will be achieved with effective life on-call
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 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