Sample Header Ad - 728x90

How to get list of tables, views etc. a users has rights to on Sybase IQ?

1 vote
1 answer
12014 views
I'm looking for a way to get a list of views, tables, procesdures etc, a user has been granted to. A select onto SYSROLEGRANTS helped me to find basic role of users -- but not more like this. So e.g. Having this: create or replace view myFancyView as SELECT * from mytable; GRANT SELECT ON myFancyView TO myUser; I'm hoping for a list like that: |User | Right | |------|----------------------| |MyUser| SELECT ON myFancyView|
Asked by frlan (495 rep)
Mar 27, 2014, 03:07 PM
Last activity: May 15, 2014, 02:07 PM