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 |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-11-20 : 04:58:31
|
| please provide scripts to create a new user name as belowUser Name : ezbillPass : ezbill This user must have read only access to the 4 views alonehelp me in giving scripts for that |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-20 : 09:56:43
|
| Create Login: http://msdn.microsoft.com/en-us/library/ms189751(SQL.90).aspxCreate User: http://technet.microsoft.com/en-us/library/ms173463(SQL.90).aspx |
 |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-11-24 : 04:07:04
|
| Hi Russel,i have to create a user and he should view only 4-5 views and the rest of the objects he can't see those.how can i give script for that. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-24 : 10:45:32
|
| GRANT SELECT ON VIEW To <user> |
|
|
|
|
|
|
query help