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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 permission to create view /table

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-02-29 : 05:17:11
what is permission for give user to create/alter view/table in DataBase Specific?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-29 : 11:20:22
I'll give them db_datawrite role
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-02-29 : 17:30:19
grant him ddl_admin.
Go to Top of Page
   

- Advertisement -