| Author |
 Topic  |
|
|
kdeutsch
Yak Posting Veteran
USA
75 Posts |
 Posted - 01/22/2013 : 17:37:00
|
Ok,
bad implimentation i am trying to correct. What we have is a sql account that our asp applications use that has full permissions to the sql server, really bad. trying to correct it by createing a basing public account that needs , dbcreator, datareader, datawriter and ability to run stored procedures and look at views.
So i created the account but how can i assign the roles of datareader and writer globally and run stored procs without having to go into each db to do it.
Thanks |
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 01/23/2013 : 21:54:21
|
| Why Full Permission? Do you have DBA or no? |
 |
|
|
Peter99
Constraint Violating Yak Guru
471 Posts |
Posted - 01/24/2013 : 09:51:20
|
Right click on login name, select properties, select user mapping, in top window "users mapped to this login" select select database name, in lower winow "database role membership" select permissions you want to give.
|
|
|
|
kdeutsch
Yak Posting Veteran
USA
75 Posts |
Posted - 01/24/2013 : 11:26:17
|
hi,
No DBA, I created everything want I am wonder though is instead of each database over 120, can I set it globally to be a dd_Reader, DB_Writer and execue on SP's. instead of having to go into each DB to do this.
Thanks |
|
|
|
srimami
Posting Yak Master
152 Posts |
Posted - 01/29/2013 : 03:42:01
|
Execute the following script to assign permissions for all the databases:
sp_msforeachdb
exec sp_addrolemember @rolename='db_datareader', @membername='THE_LOGINAME'
Note: Please work on syntax errors |
|
|
| |
Topic |
|
Create User Account
