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 |
|
juancabrera
Starting Member
30 Posts |
 Posted - 2009-04-01 : 02:16:42
|
| hello world,I am trying to grant create and alter view permissions to a specific user on a database. I am doing this through the SQL Server Management GUI. Here is what I did:1. Created a new database Role (ABC)2. Granted the Role Create and Alter permission for Views and Schemas on the DB.3. Applied ABC DB Role to Windows User1.Now that the windows user is trying to Create Views he is not able to. Am I missing something? Please this is urgent. I don't want to make this user db_owner. Your help is most appreciated. Thanks. |
|
|
juancabrera
Starting Member
30 Posts |
Posted - 2009-04-01 : 02:39:10
|
| I'll take that back the Windows user is part of a windows security Group. So it actually is more like this.1. Windows user1 belongs to windows group12. Windows group1 is added to the SQL Server Instance.3. I map the windows group1 to database DB1 and give it db_reader and db_writer roles.4. I Create Role ABC on DB1 and grant Create View permissions.5. I make windows group1 part of the ABC DB1 Role.6. The user logs in to SQL Server management Studio using Windows Credentials.Shouldn't the user be able to create views now? He keeps getting a message saying that he doesn't have permissions to create views. Any ideas? |
 |
|
|
juancabrera
Starting Member
30 Posts |
Posted - 2009-04-01 : 17:05:29
|
| I don't understand why this would work, but I asked the user to log off and log back in from windows and it fixed the problem. The user had already been a part of the AD Group. And No the user didn't leave his computer up for 3 months. So why would this make it work? I thought SQL Server permissions are effectively after the user logs off from SQL Server and logs back in to SQL Server. Any explanations? |
|
|
|
|
|
|
Grant Create and Alter View permissions in Databas