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 18, 2012 at 1:45 pm

    #1569766

    Welsh Corgi (12/14/2012)

    This is not a bug.

    The User has been denied the CREATE VIEW Permission.

    Try revoking the deny permission.

    REVOKE CREATE VIEW TO [UserName]

    I have issued the following

    USE [dbname]

    GO

    REVOKE CREATE VIEW FROM <username>

    It completed successfully; but the user has been out of office - so I cannot test it yet. It's his domain account and we're not allowed to have his password. Since it's 2000, I cannot use EXECUTE AS, correct?