Re: Grant Insert Permission Freezing

Run SQL Server Profiler to see what is going on while you grant permission





<juustagirl@xxxxxxxxx> wrote in message
news:1186787274.633524.104620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have one table that I cannot grant permissions on.

I have tried through Enterprise Manager and by executing at statement
like:

GRANT SELECT on dbo.YYY to ThisRoleName

I am db owner. I kicked everyone out of the database so I am the only
person in there. I can grant permissions to any other table in the
database. But when I try to grant permissions to table YYY the
request eventually times out.

Any ideas would be most appreciated!



.

Relevant Pages

  • Re: Ownership Chains Not Working?
    ... I agree with Sue. ... I grant permissions only to user-defined ... > database A has all kinds of privileges that I don't want this user to have ...
    (microsoft.public.sqlserver.security)
  • Re: its THREE times that i post Really wanna solve this!!!!!
    ... >> Cannot open user default database. ... > the caller is assumed, in most cases this is the ASPNet account, you need ... > to grant permissions on your database to this account. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Deny permission to the object browser in query analizer
    ... you grant permissions to though. ... determined table in a database. ... objects thru the object browser in the query analizer. ...
    (microsoft.public.sqlserver.security)
  • Re: its THREE times that i post Really wanna solve this!!!!!
    ... This could also be because you set your account to have ... a default database other than master. ... >>> Cannot open user default database. ... >> to grant permissions on your database to this account. ...
    (microsoft.public.dotnet.framework.aspnet)
  • User permissions
    ... Is there a transact-sql or other way that I can use to ... grant permissions to all objects in a database to a ... Enterprise Manager. ...
    (microsoft.public.sqlserver.security)