Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    5

    Unanswered: List of users that have access to tables

    Hi,

    I'm in need of help please

    I need to get a list of users and the group that they belong to as well as which tables they have too.

    Thanking you in advance

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    login to sybase
    1> use <dbname>
    go
    select name from sysusers
    go

    this would give you the list of users int eh database

    for whichever user you need infor about, do

    1> sp_helprotect <user_name>
    2> go

    this would give the list of permissions for the user.

    suda

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    To get a list of database users:

    SELECT uid, name
    FROM sysusers
    WHERE gid != uid

    For each user, you must then query the sysprotects table:
    http://infocenter.sybase.com/help/in...s/tables51.htm

Posting Permissions

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