Re: GRANT SELECT slow performance

From: BP Margolin (bpmargo@attglobal.net)
Date: 05/31/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 30 May 2002 22:24:37 -0400

Lee,

Check out this earlier thread ... I know that that the link will word wrap,
and that you will have to cut and paste it into your browser ... sorry about
that ;-(

http://groups.google.com/groups?hl=en&lr=&ie=UTF8&oe=UTF8&threadm=uQu84DN0BH
A.392%40tkmsftngp03&rnum=1&prev=/groups%3Fq%3D%2522bp%2Bmargolin%2522%2Btibo
r%2Bgrant%2Bgroup:microsoft.public.sqlserver.*%26hl%3Den%26lr%3D%26ie%3DUTF8
%26oe%3DUTF8%26selm%3DuQu84DN0BHA.392%2540tkmsftngp03%26rnum%3D1

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Lee Coffelt" <coffelt@wt.net> wrote in message
news:32756d2b.0205301418.354f0805@posting.google.com...
> 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

Relevant Pages