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 |
|
gattukoli
Starting Member
4 Posts |
 Posted - 2009-03-23 : 03:25:30
|
| Hi,I am having a database where my actual data is stored. No I have created another database and created views of the data which is in the previous database. Also, I have created a new login. Now, I want to give this new login the rights to use only the second database which is containing the views. The user should not be able to access the main database How to do that. Please help.Thanks |
|
|
Lambik
Starting Member
13 Posts |
Posted - 2009-03-23 : 07:22:59
|
| Just give the user rights in the second database where your views are stored. And don't give the user rights in the first database. But why not just use one database? It is possbile to give permissions per table or per view.Lambik |
 |
|
|
gattukoli
Starting Member
4 Posts |
Posted - 2009-03-31 : 09:57:02
|
| Yes I know. But how to do that.Can you please give me the step by step procedure. |
|
|
|
|
|
|
Database user rights