Results 1 to 3 of 3

Thread: SA rights

  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: SA rights

    Is there a way in SQL server to grant "SA" rights to non-SA users for certain commands.

    I know there's a way to do this in Sybase by creating a password protected role and then activating it within a stored procedure.

    Thus, the specific right is only active for the brief duration of the stored procedure - which runs the particular command to be granted. The role is de-activated at the end of the stored procedure.

    Any suggestions are greatly appreciated.

    Thanks,

    Isaac

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: SA rights

    sp_addrolemember and sp_droprolemember

  3. #3
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: SA rights

    Originally posted by ieruiz
    Is there a way in SQL server to grant "SA" rights to non-SA users for certain commands.

    I know there's a way to do this in Sybase by creating a password protected role and then activating it within a stored procedure.

    Thus, the specific right is only active for the brief duration of the stored procedure - which runs the particular command to be granted. The role is de-activated at the end of the stored procedure.

    Any suggestions are greatly appreciated.

    Thanks,

    Isaac
    You could try an application role - looks like it is what are you looking for. See BOL for details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •