February 5, 2007 at 11:30 pm
The Query,
SELECT OBJECT_NAME(id) as ObjectName,
USER_NAME(uid) as UserName, protecttype,
action, USER_NAME(grantor) as Grantor
FROM sysprotects
WHERE id = object_id('syslogins')
The above query will give me output like this=>
ObjectName | UserName | ProtectType | Action | Granter |
syslogins | public | 205 | 193 | dbo |
syslogins | public | 206 | 193 | dbo |
syslogins | perfstat | 205 | 193 | dbo |
but i want some replacement as
GRANT instead of 205 | |
REVOKE instead of 206 | |
SELECT instead of 193 |
i.e output will look like as =>
ObjectName | UserName | ProtectType | Action | Granter |
syslogins | public | GRANT | SELECT | dbo |
syslogins | public | REVOKE | SELECT | dbo |
syslogins | perfstat | GRANT | SELECT | dbo |
Is it possible..?
I will be Heartly Thankful for Any Help....
February 6, 2007 at 3:00 am
Hello,
You could build a tiny table with the translations to join with. Since the values are hardcoded in INFORMATION_SCHEMA.TABLE_PRIVILEGES it isn't likely that the translationtable is already there.
If you lookup sysprotects in the bookonline it gives you (most of) the possible values
February 6, 2007 at 9:32 am
Or use a case statement if there are not too many values.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy