Post reply

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

  • June 11, 2009 at 2:17 am

    #205364

    I have given a user rights to db_datareader and db_datawriter.

    I have then created a new role with permissions deny delete and grant create views.

    When i tried to create a view it gave the following error: The specified schema name "dbo"

    > either does not exist or you do not have permission to use it.

    Then i granted alter any schema right on my new role - then i could create a view no problem but i can still delete tables even though i have deny delete rights ??

    Any solution to this?

  • June 11, 2009 at 2:01 pm

    #1008234

    I seems that the database role datawriter is cousing you the problems, remove that db role and grant specific access writes the db objects for that user.

    Oded

    www.dbsnaps.com

    www.orbiumsoftware.com

  • June 12, 2009 at 12:25 am

    #1008407

    Removoing that right does not work - I am still able to delete tables then, I think it had to do with the grant that i have on my database role - Alter any schema grant.

    But if i remove that i cant create view's anymore even though i have the grant view rights

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

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