Post reply

User Permissions

  • April 2, 2003 at 4:38 am

    #58844

    I need a quick way to see what permissions and databases users have access to.

    Is ther a stored procedure or script to do this??

  • April 2, 2003 at 7:27 am

    #452822

    There are a couple of stored procedures you can look into to get the information you are looking for. My favorites are sp_helprotect, sp_helpuser, sp_helplogins.

    You can also look up "system stored procedures, listed" in BOL and get a full listing of all the system stored procedures associated with security.

    Hope this helps.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • April 2, 2003 at 8:22 am

    #452836

    Thanks alot sp_helpuser did the trick

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply