Re: Grant Insert Permission Freezing

Execute sp_who to list current activity. Perhaps there is a rogue process blocking your request.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<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: Stored Procedures in the Master Database
    ... Did you fully qualify the stored procedure when executing ... I am trying to grant permissions with the ... >following command in the master database: ... >When I try to execute the stored procedure from another ...
    (microsoft.public.sqlserver.security)
  • Re: is there a problem on this simple code
    ... Always start a new thread when you have a new request. ... error on the thread that's the time that other part of the program got the chance to be executed even the timer even is not executed while the thread is running ... out how you are getting "someTimerEvent" to execute, ... and "pleaseee" will ...
    (comp.lang.python)
  • System.UnauthorizedAccessException: Access to the path ...Temporary ASP.NET Files.. is denied.
    ... Whenever I execute the application it gives, Unauthorize Exception ... granting access rights to the resource to the ASP.NET request identity. ... to the ASPNET user account and to the Developer. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to set Timeout with URL Moniker?
    ... > We use a URL Moniker to make an HTTP/S request to a script which can ... > take sometimes several minutes to execute. ... I've tested and our script executes successfully and returns ...
    (microsoft.public.vc.language)
  • Re: HTTP Download of EXE
    ... that's what you configured the server to do... ... Given a request, IIS has to determine whether to serve the file (i.e. ... Execute Permissions of "None" means everything is treated as a static file ...
    (microsoft.public.inetserver.iis)