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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-10-11 : 05:07:20
|
| which query should i run to alter the priviliges of all databases (and how for certain databases )for a certain user where i want to give him a deny access to select/insert/delete ?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-10-11 : 05:18:04
|
| Search for Grant on BOL there is good examples over there.. hope they suits your requirement..Complicated things can be done by simple thinking |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-10-11 : 05:32:27
|
| what is BOL?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-11 : 05:44:40
|
| "Books Online" - bit of a misnomer really as they are installed with the client tools.They are also available online in the MSDN section of SQL Server.Kristen |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-10-11 : 05:44:59
|
| ooooh....BOL = Books OnLine (Searching here would have found you that answer!!!!)From the number of your recent questions, I think you need to investigate it...it's the most basic tool (and potential best friend) for any DBA/SQL Developer. |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-10-11 : 06:25:01
|
| ok AndrewMurphyi will take your remark in considerationIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
updating all tabled grant at once