title: How to list user and role assigned to them in Sybase DB
body: <p>Kindly help me with SQL statement which can list the users and the role assigned to them in Sybase DB.</p>
  
  <p>Need to capture  users\roles who have following authorisations:</p>
  
  <pre><code>ALTER ANY TABLE
  CREATE ANY TABLE
  DELETE ANY TABLE
  DROP ANY TABLE
  GRANT ANY ROLE
  UPDATE ANY TABLE
  DROP ANY ROLE
  GRANT ANY OBJECT PRIVILEDGE
  GRANT ANY PRIVILEDGE
  ALTER USER
  ALTER PROFILE
  ALTER DATABASE
  BECOME USER
  CREATE ANY RULE
  DROP USER
  </code></pre>