1

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|
frlan
  • 499
  • 4
  • 26

1 Answers1

1

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1570/html/sprocs/X22708.htm lists the system stored procedure, sp_helprotect which provides a mechanism for displaying all the rights a user has in a given database.

From that document:

Displays all the permissions that “judy” has in the database:

sp_helprotect judy

Community
  • 1
Hannah Vernon
  • 66,859
  • 22
  • 158
  • 297