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
Last activity: May 15, 2014, 02:07 PM