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 |
|
koteswarrao
Starting Member
1 Post |
 Posted - 2008-01-24 : 09:35:26
|
| hiThru QAi have created a login & rolei have granted select persmission to role (only two columns in a table can access)like this: grant on select <tablename>(<columnlists>) to <rolename>it has successfully completed.In Enterprise manager is has show checkmark with green in granted columns.but when i issues execute all columns(select * from <tablename> ) iam able to get all columns rather getting error message access denied.plz tell the solutionkoteswarrao |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-24 : 23:08:47
|
| Did you put user to other roles? |
 |
|
|
|
|
|
Security-grant option