sql server (alternate): sp_helprotect COLUMN has NULL value -- sql server (alternate)

sp_helprotect COLUMN has NULL value

serge
5/28/2006 8:01:06 PM

sql server (alternate):

Does anyone know what it means when i see some
records returned that have their COLUMN value
as NULL?

I investigated a little to see if they are somehow
related to orphaned users but I don't believe they
are. What else would cause this column to be NULL?

And it seems they are all MSP related. Maybe this is
a Project Server bug?

Here's one sample:

Owner dbo
Object MSP_WEB_FN_SEC_GetAllProjectsResCanViewByViewID
Grantee MSProjectServerRole
Grantor dbo
ProtectType Grant
Action Select
Column NULL

Thank you

Re: sp_helprotect COLUMN has NULL value

Erland Sommarskog
5/29/2006 9:55:23 PM

serge (sergea@nospam.ehmail.com) writes:
[quoted text, click to view]

I don't have Project Server installed.

But if you want to dig further "sp_helptext sp_helprotect" can keep
you busy a little while. :-)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at