Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Unanswered: How to get user list

    Hi,

    How to get list of all users,roles and database in the Sybase ASE.


    Thanks

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    use:
    select name as user_name
    from sysusers

    to get a list of all users in the current database.

    select name
    from master.dbo.sysdatabases

    to get a list of all databases.

Posting Permissions

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