Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ddl_admin Expand / Collapse
Author
Message
Posted Wednesday, November 19, 2008 11:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 3, 2010 2:42 PM
Points: 1,023, Visits: 1,893
can ddladmin role create tables in a DB?
Post #605303
Posted Wednesday, November 19, 2008 11:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 23,289, Visits: 32,016
From Books Online (BOL) :

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.


So, answer, yes.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #605316
Posted Thursday, November 20, 2008 9:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 3, 2010 2:42 PM
Points: 1,023, Visits: 1,893
I was just trying to find out all the diffeerences between ddladmin and dbowner.
Post #605924
Posted Thursday, November 20, 2008 9:38 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 23,289, Visits: 32,016
Books Online should be able to answer all your questions about the fixed server and database roles.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #605927
Posted Monday, November 5, 2012 10:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 9:13 AM
Points: 98, Visits: 1,110
Hi,

I wonder if you could clarify for me that if i provide a programmer DDL_Admin on a database does this allow them to execute a stored procedure that they have just created against the database they are mapped to with DDL_Admin permissions.

Only it gives them pretty much all they need i.e.Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

Yet i still have to explicitly grant them Execute permissions on the their SP.
Your help would be greatly appreciated.


Post #1381183
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse