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
 General SQL Server Forums
 New to SQL Server Programming
 Permissions for creating Database?

Author  Topic 

softwareenganeer
Starting Member

2 Posts

Posted - 2009-11-05 : 00:37:00
Hi,

I am trying to installing my application with SQL server 2005, While installing my application, i would like to create Database Schema with respect to my application so for creating the database schema do i need full access permissions of SQL Servver? I mean do i need create, Insert, select, update permissions for creating Database schema?

Regards,
BSK

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-05 : 01:33:14
You would need DDL permissions. There's a database role that gives these permissions and it's db_ddladmin.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

softwareenganeer
Starting Member

2 Posts

Posted - 2009-11-06 : 06:19:10
Hi Tara Kizer,

Thanks for your reply. I have one more doubt like
Can i add few more tables to already created SQL Database schema?

I have installed one product with SQL server, While installing that product, It creating one Database schema but i want to add few more tables to that created Database schema. Is it possible?


Regards,
BSK

Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-06 : 10:26:14
I give you permission...

Wait...

Tara, why not just Grant them dbo?

You don't need sa, which is full control over sql server



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-06 : 11:03:54
I like to grant the least amount of permissions that are required. Sure dbo would satisfy the request, but it's more than what's being asked for.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -