Create and Alter Table Permission only for specific schema

Question

Post reply

Create and Alter Table Permission only for specific schema

shadow_2

Right there with Babe

Points: 773
More actions
July 8, 2010 at 3:25 am

#226608

Hello experts,
I need advice on how to grant create table, alter table and create procedure permissions on a specific schema to a specific user.
I set the user to be the schema owner and thought this would suffice - but it doesn't.
Thanks in advance,
Steffen.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90349 More actions · Answer 1

Explicitly grant permissions on the schema, for example:

GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

shadow_2 Right there with Babe Points: 773 More actions · Answer 2

I'll give it a try on monday, thank you Jeffrey.

Steffen

SQL_Helper SSC Eights! Points: 837 More actions · Answer 3

Hi;

I want to grant privileges in sql server 2005 to a db user to create and alter tables.

can anyone helpe me on this.

Thanks

ejoell 66477 Right there with Babe Points: 778 More actions · Answer 4

ejoell 66477

Right there with Babe

Points: 778

September 28, 2011 at 2:22 pm

#1388077

Grant create table to username

Grant alter to username

daves127 SSC Rookie Points: 41 More actions · Answer 5

Jeffrey Williams 3188 - Friday, July 9, 2010 1:47 PM
Explicitly grant permissions on the schema, for example:GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;

"GRANT CREATE TABLE ON SCHEMA::."... is not valid.

Jeff Moden SSC Guru Points: 1004601 More actions · Answer 6

ejoell 66477 - Wednesday, September 28, 2011 2:22 PM
Grant create table to usernameGrant alter to username

Heh....
GRANT Perpetual Headaches to DBA

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Create and Alter Table Permission only for specific schema

Cookies on SQLServerCentral