November 26, 2008 at 5:27 am
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). Please note that i am looking table--> properties-->permission and under permission. I can see "view schema permission", there is nothing defined. I can see the "view database permission" under schema property, there i can see my windows user id having "connect" permission.
Where can I see the table level permission
November 27, 2008 at 3:16 am
There are probably no permissions granted on table level. It's actually a well-known practice to do all select\insert\update \delete through stored procedures or views and not granting any direct permissions on the tables. That's not new to SQL 2005.
Another option could be that your users are member of the datareader role. This would give them select permission on all tables and views, but it won't show under the table properties.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply