Home Forums SQL Server 7,2000 Security DB_OWNER Privilege but Unable to create views RE: DB_OWNER Privilege but Unable to create views

  • December 14, 2012 at 8:59 am

    #1568754

    MSSQL_NOOB (12/14/2012)

    Welsh Corgi (12/13/2012)

    What is the specific Error Message?

    CREATE VIEWS permission denied in database 'DBNAME'.

    Edit:

    I actually found http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/bfd630bc-e405-4f9d-b63f-f673b3f4ccf5/

    that has the same issue. They are saying it was a bug in MS.

    This is not a bug.

    The User has been denied the CREATE VIEW Permission.

    Try revoking the deny permission.

    REVOKE CREATE VIEW TO [UserName]

    For better, quicker answers on T-SQL questions, click on the following...
    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/