Re: User can't be deleted because it has granted/denied permissions on objects

Tim,

This is documented in the Books Online (the SQL Server developer's best
friend). Here is a snippet:

sp_helprotect [ [ @name = ] 'object_statement' ]
[ , [ @username = ] 'security_account' ]
[ , [ @grantorname = ] 'grantor' ]
[ , [ @permissionarea = ] 'type' ]

So, use the appropriate parameter for your need. Sorry, but I (blush)
misread the topic.

sp_helprotect @grantorname ='yourusername'

RLF

"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:ueIzFmr2HHA.212@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the reply!!

This is showing me all the entries where the user in question is the
grantee....not the grantor. How can I see everything where it is the
grantor?


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:OXZN6Qr2HHA.4720@xxxxxxxxxxxxxxxxxxxxxxx
Tim,

sp_helprotect @username='yourusername'

This should show you all grants and denies for the user.

RLF
"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:e3LeW9p2HHA.4720@xxxxxxxxxxxxxxxxxxxxxxx
How to determine what it has granted/denied? I've been tasked with
restoring a 3rd parties database and we're cleaning up some things
including
the plethora of sql login/users and going to all domain based groups. I
cannot delete this one user. I've transferred all objects owned by it
to
another user but still get this message.

I'm stuck..
Thanks for any insight here!







.

Relevant Pages

  • Remote development advice
    ... My friend and I are entrusted to develop a small web based application ... using ASP and SQL Server database. ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ...
    (microsoft.public.dotnet.general)
  • arggggg... adodb.connection error... help
    ... I have a laptop computer I routinely use at home for regular stuff ... have VB6 and SQL Server installed on the laptop. ... About 6 months ago I wrote an ASP app for my friend which performs some ...
    (microsoft.public.data.ado)
  • Re: Access in wireless PDA scanner
    ... Access doesn't work with mobile devices ... you need to use SQL Server ... operations in a tiny warehouse of a friend of mine. ...
    (microsoft.public.access.devtoolkits)
  • (ACCESS or Dot.Net ) + SQL server for a simple multiuser aplication
    ... A friend of mine who is familiar in Dot.Net programming is advicing me not to ... of SQL server is seriously diminishing if there are more ACCESS Front Ends ...
    (microsoft.public.access.adp.sqlserver)
  • Re: (ACCESS or Dot.Net ) + SQL server for a simple multiuser aplication
    ... > I am about to start developing a multiuser aplication using SQL-server ... > A friend of mine who is familiar in Dot.Net programming is advicing me not ... > of SQL server is seriously diminishing if there are more ACCESS Front Ends ...
    (microsoft.public.access.adp.sqlserver)