August 25, 2008 at 1:25 pm
I am trying to list all the user permissions on all objects for a Domain ID "Racks\rsp-hr-admin" . The user name is rsp-hr-admin in the SQL database for the above login. Its a member of different roles.sp_helprotect is giving me this error
sp_helprotect null, [rsp-hr-admin]
or
sp_helprotect null, 'rsp-hr-admin'
or
sp_helprotect null, 'Racks\rsp-hr-admin'
Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346
There are no matching rows on which to report
August 25, 2008 at 2:11 pm
Do you see this user entry in sp_helpuser output(Users Column)?
sp_helpuser
I did the same on my instance and it is working fine as user is listed out there.
Or Try this:
This lists permissions in every database in an instance.
--Lists a user's object permissions in every database. Specify the user name.
sp_MSforeachdb 'use ? Print DB_Name() select cast(o.name as varchar(45))as ''object''
,case p.action
when 193 then ''SELECT''
when 195 then ''INSERT''
when 196 then ''DELETE''
when 197 then ''UPDATE''
when 224 then ''EXECUTE''
else '' ''
end as ''permission''
from sysprotects p join sysobjects o
on o.id = p.id
where p.uid = (select u.uid from sysusers u
where name = ''XXXX_Application'')'
HTH ,
MJ
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply