RE: Create table rights

From: DBADave (DBADave_at_discussions.microsoft.com)
Date: 08/30/05 

Date: Mon, 29 Aug 2005 17:01:02 -0700

With the specific 'create table' permission or the DDLAdmin role membership
that should permit the user to creatr the table.

How is the user atempting to create the table? Are they executing a DDL
script? If they are executing a script, make sure that the CREATE TABLE
script does not have the dbo context set in the table name. If it does, and
the user executing the scriipt is not a DBO, then they will be unable to
successfully create the table. If the script does have dbo. in the table
name, just remove the dbo. from the name and try executing it.

"jaylou" wrote:

> 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

  • Jumpstart: syntax error and trying to load from /cdrom media, which disk to use for Solaris 8 image
    ... I'm not sure if I need to use that disk or the Solaris 8 Installation ... Using RPC Bootparams for network configuration information. ... Using finish script: diag_drv.fin ... Executing JumpStart preinstall phase... ...
    (SunManagers)
  • Re: understanding lambda
    ... All functions in the script are created when the script is parsed. ... A lambda function is created when the script is executing - and is not created unless that statement is executed. ... a new solid -- say, a cylinder, I would take two steps: ...
    (alt.php)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... I have seen some scripts executing from a ... Gouvernement du Canada / Government of Canada ...
    (comp.os.linux.development.apps)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... takes root privileges to do so. ... I have seen some scripts executing from a ...
    (comp.os.linux.development.system)
  • Re: What does this script do?
    ... This is the Machine Startup script: ... dim installMediaPath, installMediaFileName ... local drive and executing it. ...
    (microsoft.public.scripting.wsh)
Quantcast