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 |
|
tmdavis1
Starting Member
6 Posts |
 Posted - 2008-01-11 : 07:47:30
|
| I need to create a new login with SELECT rights so the users can view all tables with no UPDATE, DELETE, OR INSERT rights. But this user needs to be able to CREATE VIEWS. I have assigned the user to the Public role and gone in and modified Securables for the Database to be able to CREATE VIEW. When I connect using my new user and try to create a view, I get the error message: CREATE VIEW permissions denied in database 'test01'.Help PleaseTMDavis |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-01-11 : 10:24:41
|
| You can add the user to the database role db_ddladmin. That (itself) will not allow the user to insert/update/delete rows but they can create views. But they also can delete tables that exist in that database. If the user had db_datareader in database1 and db_ddladmin in database2 they are able to create views in database2 that read from tables in database1. But cannot drop tables that exist in database1.Be One with the OptimizerTG |
 |
|
|
|
|
|
User permissions - Read only with Create View