var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Script to determine which tables a use has access to.
I need help on determing if a user has access to tables or has anyone done that before?
Thanking you in advance
Thanx for the reply
When I execute the command i get the following error
Error: Procedure 'sp_helprotect' not found (State0002, Native Code: FFFFFEF7)
Is there a way around this...
Which Sybase product and version are you using?
Try the following if the table is tester and owner is ishu
then query will be
select table_name,(select user_name(grantor)) grantor ,(select user_name(grantee)) grantee,selectauth,insertauth,deleteauth,updateaut h,updatecols,alterauth,referenceauth
ttable_id = table_id and table_name = 'tester' and creator = user_id('ishu')