|
Home > Archive > MS SQL Server security > January 2006 > Stored Procedures Permissions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Stored Procedures Permissions
|
|
| Prasad 2006-01-12, 3:23 am |
| 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
| |
| Wayne Snyder 2006-01-12, 7:23 am |
| 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
>
>
>
| |
| Razvan Socol 2006-01-12, 9:23 am |
| > 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
| |
| Prasad 2006-01-17, 3:23 am |
| --> 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.
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:977FC151-7291-42D1-9432- 1BE9EA2F0E5F@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|
|