Results 1 to 7 of 7
  1. #1
    Join Date
    May 2002
    Posts
    47

    Unanswered: table design for presentation

    I need to report on what users have what permissions. This is the way we have it stored currently. There must be a better way to store or retrieve this info. in a warehouse. Ideas?

    Thanks,

    -Kevin

    USER read write execute change UI create proc.
    joe x x x
    bill x x
    bob x x x

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run SP_HELPROTECT to return access information for all the users in a database.

    And you can generate SQL scripts to script the permission for specific user or users to a .SQL file and use in case if needed.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2002
    Posts
    47

    not system info.

    Actually that was just an example. The permissions I have in my table are for our intranet site.
    My questions was in reference to a better table design.

    -K

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    try writing a query to the sysobjects sysusers sysprotects tables
    you can see the definition of the protecttype in books online
    just check out each of the tablenames in books online.

    i also suggest if you go this way that you download a copy of systbl.chm from Here
    it's very useful for debugging system table stuff and there are only a few mistakes in it.
    (it says it's for 2000 but it's from 7.. syslogins is called sysxlogins in 2000)

  5. #5
    Join Date
    May 2002
    Posts
    47

    nothing to do with SQL permissions

    Did you read my reply to the last message.
    This has nothing to do with SQL permissions or system tables.

    -KEvin

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    If you want to create tailor made report then you may use own code to refer so, if not the referred the specified SP.

    Or could you please come up with details what exactly you want to achieve.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    i agree, not enough info.
    please give some tables definitions and an example of what you want to achieve.

Posting Permissions

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