Post reply

Access

  • September 28, 2005 at 12:57 pm

    #187831

    How should I know who many users have access on particular database

    for example:

    user mary has access as readonly on pubs database

    Thanks

    Nita

  • September 28, 2005 at 1:47 pm

    #593822

    Nita,

    to visually see in Enterprise manager expand the database and in Users container see all users, when opening user's properties (double-click) you will see the permissions.

    to summarize by script use syspermissions table to see permissions applied to objects- tables etc or sysprotects to see permissilons granted or denied to a user or a role

    Yelena

    Regards,Yelena Varsha

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

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