1
vote
1answer
984 views

Limiting user access to tables based on a ROLE

I have a SQL Server 2005 database to which I would like to LIMIT access. I have done the following: Created a database role called NO_HR Added the tables to this role under Securables that should be ...
5
votes
2answers
132 views

Will a SP which writes records fail if accessed by a db_datareader role?

I have a stored procedure which is accessed remotely by an app which is running on some kind of Java/WebSphere type platform. It takes one argument, returns some data and that's that. Recently there ...
3
votes
2answers
159 views

SQL 2005 Permission Precedence

Very simple question - I have two database roles (Basic, Admin). Say I explicitly deny the Basic role from deleting from table A and grant that to the Admin role. If I am a user who is in both ...
1
vote
1answer
1k views

SQL Server 2005 Easy way to add all users to a database role

I have three application databases: A, B and C. Users of A and B are all users in C; the users from A are in the public role with only SELECT permission, while the users from B are in a role with more ...