Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Angry Unanswered: Database object permissions

    Hello Gurus,

    Please tell me how can I find the SQLServer2000 userlist with details
    like: username,
    logininfo,
    database,
    table,
    what permissions user has like read/write/ddladmin/dbo etc

    I would like to create a query which gives me these basic info so that I can make changes if a user has additional previleges.

    Many thanks if anycone can help me with the query text. I want to run it from the master database.

    Thanks in anticipation of help.

    Vinnie

  2. #2
    Join Date
    Sep 2003
    Posts
    2

    Post Re: Database object permissions

    Try the sp_helplogins Stored Procedure. Should give you the info you need

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

    Re: Database object permissions

    Originally posted by Moridin
    Try the sp_helplogins Stored Procedure. Should give you the info you need
    master db:
    syslogins
    sysdatabases

    user db:
    sysusers
    sysobjects
    syspermissions

Posting Permissions

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