RE: Create table rights

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

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

hi Jose,
Is there a way to find out if he is being denied? I have granted him
DB_DDLADMIN rights to the database. that should over ride the deny correct?

Thanks,
Joe

"Jose G. de Jesus Jr MCP, MCDBA" wrote:

> i think the user is be a member of a denied group
> or he is denied as an individual
>
>
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787
>
>
> "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

  • RE: Users and Truncate Table
    ... Jose de Jesus Jr. ... MCP #2324787 ... >> Sykes Asia (Manila philippines) ...
    (microsoft.public.sqlserver.security)
  • Re: is there a better way to do this???
    ... Any arbitrary row may be returned. ... "jose g. de jesus jr mcp, mcdba" <jose g. de jesus jr mcp, ...
    (microsoft.public.sqlserver.programming)
  • Jose 1.4 available for download
    ... a new version of Jose is available for download at: ... * bundled chess engines: TogaII and Spike. ... database features are a bit unreliable. ... If you're using Jose as a database tool on Mac OS X ...
    (rec.games.chess.computer)
  • Re: Unable to merge 2 mySQL Databases using OdbcDataAdapter.Update
    ... > Hi Cor, ... > records in this table and from surce database table there is 12 records. ... > MCP Year 2005, Philippines ... >>> MCP Year 2005, Philippines ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Retrieving Actual Work with SQL
    ... I suggest that you navigate to the help directory under your ... Project Server installation directory on the server and grab the two HTML ... database as well as code samples for doing exactly what you ask. ...
    (microsoft.public.project.pro_and_server)