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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2012-01-16 : 07:14:44
|
| I'm trying to give a database role permission for all the crud operations on a particular table, when I useGRANT ALL ON MyTable TO MyRole as dboI get a message about ALL being deprecated but no indication of what has replaced it, can't see anything in bol either, am I missing something or do I now have to type it out explicitly? i.e.GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON MyTable TO MyRole as dbothankssteve-----------What color do you want that database? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
|
|
|
|
|
Simple permissions question, what am I missing?