Re: Create table rights

From: jaylou (jaylou_at_discussions.microsoft.com)
Date: 08/30/05 

Date: Tue, 30 Aug 2005 06:05:03 -0700

Hi Hari,
Here is the error I get when I try to create a table with this userID
"Server: Msg 262, Level 14, State 1, Line 1
CREATE TABLE permission denied in database 'SOXstuff'."

I don't need to add him to a server role as well as the DB_DDLADMIN?
Thanks again,
Joe

"Hari Prasad" wrote:

> Hi,
>
> Looks like some one DENY the create table previlage for that user. But in
> this case a GRANT command will over rule the DENY.
> Could you post the exact error you are getting after running the GRANT
> statement.
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
>
> "jaylou" <jaylou@discussions.microsoft.com> wrote in message
> news:8DF5770F-4D14-4ADE-A3F1-2A47AFB3AAD4@microsoft.com...
> > hi All,
> > I have given a user ddladmin to a database, but this user still can't
> > create
> > tables. I tried to "grant create tables to username" that ran sucessfully
> > but still can't create a table in my DB.
> >
> > Can anyone tell me what I missed for this user? he can drop tables but
> > not
> > create them.
> > Thanks,
> > Joe
> >
>
>
>

Relevant Pages

  • Re: Create table rights
    ... I am not logged on as databse owner or SA. ... "Hari Prasad" wrote: ... > Looks like some one DENY the create table previlage for that user. ... > this case a GRANT command will over rule the DENY. ...
    (microsoft.public.sqlserver.security)
  • Re: Users can import
    ... "Joan Wild" wrote: ... The ADH book has a function called adhSetDbCreate that will deny specified users/groups to create ... distributed workgroup file they will not be able to create a new database and link/import to the BE ... I do, however, also deny all permissions to the tables as Joan mentioned. ...
    (microsoft.public.access.security)
  • Re: Deny Create Database in SQL Server 2000
    ... Users do not have CREATE DATABASE permission unless you GRANT that permission, either explicitly or by role membership. ... Be mindful that DENY and REVOKE are different things. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: HowTo: Append data to a table stored in another database?
    ... "Lidschi" wrote in message ... > Hi Hari Prasad, ... >> SQL Server MVP ... >>> I have database A with table a and I have database b. ...
    (microsoft.public.sqlserver.programming)
  • Re: create table permission denied
    ... So even if my test login had GRANT, the DENY on public denied for test as well ... let's say 'test' and allowed access to database db1. ... I tried executing GRANT CREATE TABLE after logging on as sysadmin to that test account. ...
    (microsoft.public.sqlserver.security)