Hi everyone,
We have a newly installed SQL 2016 instance (SP1).
We've created a new user - windows authentication on the server. The user can login to the server, and database.
Because it's a DEV server we've given the user db_owner access to the selected user database.
The user wants to rename some tables on this database. Every time that he tries to rename the table (using T-SQL), he get this err:
Msg 229, Level 14, State 5, Procedure sp_rename, Line 10
The EXECUTE permission was denied on the object 'sp_rename', database 'mssqlsystemresource', schema 'sys'.
He is connected to the User DB - so it's not that he is in a different DB.
Any ideas?
Check if the user has an ALTER permission on the tables.
😎
Can you post the actual syntax the developer is using?
If the user has membership of the db_owner fixed role then this grants CONTROL of the database, ALTER is a permission inherited and implied when CONTROL is held, so no issue there.
Does the user actually have db_owner membership?
Please also post the query the user is running
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉