Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kman23
Starting Member
5 Posts |
 Posted - 2007-09-21 : 11:46:54
|
| We resent installed SQL Server 2005 and I am very new to It. Here is what I have done.Created a new user in SQL server and denied everything for a particular table to that user so that a select * from that table will result in a permissions error. Also that user cannot view the table in SQL managerThe problem now is that that user can create a stored procedure that has the SQL statement Select * from that table and execute the stored procedure to view the table. The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this? Regards, |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-22 : 22:26:15
|
| Which db role did you put the user in? |
 |
|
|
|
|
|
Permission Issues in SQL Server 2005