July 8, 2010 at 3:25 am
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.
July 9, 2010 at 1:47 pm
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
July 10, 2010 at 6:04 pm
I'll give it a try on monday, thank you Jeffrey.
Steffen
June 2, 2011 at 4:25 am
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
September 28, 2011 at 2:22 pm
Grant create table to username
Grant alter to username
September 28, 2017 at 3:29 pm
Jeffrey Williams 3188 - Friday, July 9, 2010 1:47 PMExplicitly grant permissions on the schema, for example:GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;
"GRANT CREATE TABLE ON SCHEMA::."... is not valid.
September 28, 2017 at 4:21 pm
ejoell 66477 - Wednesday, September 28, 2011 2:22 PMGrant create table to usernameGrant alter to username
Heh....
GRANT Perpetual Headaches to DBA
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy