Re: GRANT SELECT slow performance

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/31/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Thu, 30 May 2002 16:27:17 -0600

That's odd...did try running Profiler when you do a grant on
the table to see what's going on?

-Sue

On 30 May 2002 15:18:11 -0700, coffelt@wt.net (Lee Coffelt)
wrote:

>Here's the statement:
>
>grant SELECT ON PSPRCSRUNCNTL TO BWHITE
>
>When I execute it, it takes about 1.5 minutes to process. Other
>grants process instantaneously -- the problem only appears on this
>table. dbo is the owner, and it doesn't matter which user I am
>granting access to, it is always this slow. Any thoughts?
>
>Thanks,
>Lee Coffelt
>coffelt@wt.net