Stored Procedures Permissions

12 Jan 2006 7:32 AM

Prasad

Hi,
    This is for the SQL 2005 (Yukon) Server.
    Can anybody tell me what the permissions "References" means on the
Stored Procedure.
    Even if it is not possible to assign the "References" permission
explicity on the Stored Procedure it is implied if we assign the
"References" permission on the         Schema.

TIA

Regards,
Prasad

12 Jan 2006 1:17 PM

Wayne Snyder

Reference permission does not apply to SPs. It is the permission an object
owner must give to allow someone else to refer to the object with a FK
constraint

--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

Show quote

"Prasad" wrote:

> Hi,
>     This is for the SQL 2005 (Yukon) Server.
>     Can anybody tell me what the permissions "References" means on the
> Stored Procedure.
>     Even if it is not possible to assign the "References" permission
> explicity on the Stored Procedure it is implied if we assign the
> "References" permission on the         Schema.
>
> TIA
>
> Regards,
> Prasad
>
>
>

12 Jan 2006 1:23 PM

Razvan Socol

> Reference permission does not apply to SPs [...]

It is interesting to note that the following works (with no error):
GRANT REFERENCES ON SomeProcedure TO SomeUser
but the following:
GRANT SELECT ON SomeProcedure TO SomeUser
gives the error "Granted or revoked privilege SELECT is not compatible
with object.", as expected.

Razvan

17 Jan 2006 5:06 AM

Prasad

--> Reference permission does not apply to SPs.

But I can assign the "Reference" permission both explicitly and through

inheritance by assigning "Reference" permission on the Schema.

Can you tell me if this is the intended behavior.

Show quote

"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:977FC151-7291-42D1-9432-1BE9EA2F0E5F@microsoft.com...
> Reference permission does not apply to SPs. It is the permission an
> object
> owner must give to allow someone else to refer to the object with a FK
> constraint
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
>
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
>
> "Prasad" wrote:
>
>> Hi,
>>     This is for the SQL 2005 (Yukon) Server.
>>     Can anybody tell me what the permissions "References" means on the
>> Stored Procedure.
>>     Even if it is not possible to assign the "References" permission
>> explicity on the Stored Procedure it is implied if we assign the
>> "References" permission on the         Schema.
>>
>> TIA
>>
>> Regards,
>> Prasad
>>
>>
>>