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 |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2011-12-01 : 11:23:22
|
| Hi,i want to create windows user and I want to create a schema only for this user, so i can create views on this schema. Main purpose is that this users have only read rights on this schema and not all the others schemas or tables in this database.what would be best scenario?i have0. create new schema1.Create login for this user2. create user for this user in desider database with default schema on this new schema3.add role member db_datareader for this user4. create views in this schema5. grant select on this views.but when i complete these, this particular users still sees other tables as well. should I all usedeny select on whole database to this user? or is there any better practice?thank you |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-01 : 11:38:48
|
| remove them from db_datareader role. |
 |
|
|
|
|
|
Granting select on views