Post reply

grant create table

  • June 29, 2010 at 6:42 am

    #147901

    Hi,

    i am trying to grant the create table right to an idividual user because granting db_owner rights is not our policy. but when granting this, the user is not able to create a table because of a warning stating that the user misses some rights or have to be db_owner. Is there an easy way to accomplish this simple issue.

    kind regards,

    Bryan

  • June 29, 2010 at 7:17 am

    #1186351

    You also have to grant him permissions to modify the schema that the table is build on (by using grant alter schema statement). The problem is that you can’t give only permissions to create table on this schema and the user will be able to do other operations such as drop or alter other tables on this schema. If no one else knows of a way to restrict the user to create tables only, and you need to restrict it, you could do it with a DDL trigger (but I find it hard to believe that there isn’t another way to restrict the user to create table only).

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • June 30, 2010 at 5:09 am

    #1186969

    Hi Adi,

    thanks that dit it for me. to bad that just simply granting create table does not work. i am used to work with oracle , where this works much better.

    bryan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply