SQL server 2005 security

Question

SQL server 2005 security

ritesh.saluja

SSCommitted

Points: 1704
More actions
November 26, 2008 at 5:26 am

#215883

I am looking at one SQL 2005 DB and trying to understand the security implemented.
I can see a role having permission to execute certain stored procedure. The role includes one user.
I cannot see any permission details at table levels like "Select, insert2 permission (like SQL 2000).
Is the table level permission not required in SQL 2005. Say for ex. in above mentioned case the stored procedure is referring to table (may be select,insert into some table)
Where can I see the table level permission

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

This is the incorrect place to post. This forum is only for SQL Server Integration Services related issues and questions.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 2

The same permissions from SQL 2000 exist in SQL 2005.

I'm not sure what you mean by not seeing them. Are you not finding this in SSMS?

Moved to the security forum.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ritesh.saluja SSCommitted Points: 1704 More actions · Answer 4

this post is under security topics. Yes, I am using SSMS to view the security

Greg Charles SSC-Forever Points: 45403 More actions · Answer 5

ritesh.saluja (11/26/2008)
I can see a role having permission to execute certain stored procedure. The role includes one user.
I cannot see any permission details at table levels like "Select, insert2 permission (like SQL 2000).
Is the table level permission not required in SQL 2005. Say for ex. in above mentioned case the stored procedure is referring to table (may be select,insert into some table)

You'll only see the permissions that have been set for objects, not implied permissions. In your example, if a role or user has EXECUTE permission on a stored procedure that does a DML operation on a table, the role or user doesn't need table level permissions.

This hasn't changed since SQL 7.0.

Greg