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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-01-04 : 12:33:08
|
| I am new to setting up rights for users in a sql server 2008 r2 standard edition database. I am a programmer in a small company that just told me to do the dba work.Thus my question is I have a user that 'execute reader' and 'execute writer' permissions. The user can only see system tables and system stored proecuedres. They can not use the user tables and user stored procedures. Thus can you tell me what additional access level I need to setup for them? Do they need ddladmin rights? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-01-04 : 19:22:08
|
| I'm not sure what you mean by "execute read" and "ecxecute write" permissions. Are they members of the db_datareader and db_datawriter roles? Are these the names of user defined roles? Also, are they able to perform a SELECT query against one of the tables? Is their default schema the same as the schema name of the tables?In SS Management Studio->Object Explorer you can open up database's Security->Users, right click the User and check their Properties. This will show their default schema and Role memberships. The schema of the table will appear as part of its name under the Tables section of the database.=================================================Men shout to avoid listening to one another. -Miguel de Unamuno |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-05 : 00:24:43
|
| Looks like you have created a user in the database without assigning any roles to it.sp_addrolemember 'db_datareader','youruser'sp_addrolemember 'db_datawriter','youruser'After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
sql server permissiobns