Problems with Grant Create Table on a database

dfr031260
dfr031260 used Ask the Experts™
on
Have granted create table to a SQL Server userid, and when I check the userid in Management Studio the grant is in place, but when I attempt to create a table as this user I get:

The specified schema name "dbo" either does not exist or you do not have permission to use it.

What am I missing...

Dav
create table dbo.testerito
(testid int)
go

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
you should explicitly grant ALTER/Create SCHEMA permissions for that user

GRANT ALTER ON SCHEMA::dbo TO username
Mohed SharfiVice CEO

Commented:
Hi
with this Query you can sure for your permissions
thanks
SELECT * FROM sysobjects a
LEFT JOIN syspermissions b
ON a.id=b.id
WHERE a.xtype='P'
AND b.id IS NULL 

Open in new window

Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
the error means what it says: the user cannot create a table in the schema dbo.
you would need to add the role db_owner to that user, granting that user full access to the database.

Author

Commented:
Worked like a charm...Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial