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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2012-04-17 : 02:59:03
|
| Hi All,I Have a user say MYUSER, MYUSER has all permission(db_owner, dbcreator, sysadmin) to all databases. I need to remove those permissions and give only datareader and datawriter permission. How to do it. ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-17 : 15:20:15
|
| using SSMS, expand the security node, uncheck the roles you don't want in the server roles page.Then go to each database, expand the security nodes there and uncheck db_owner database role. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Doubt in assigning/removing roles to an user for a