January 14, 2016 at 1:58 pm
Hello, is it possible to disable or deny permissions for users to create in-memory OLTP tables in 2014/2016? We are working on upgrading our servers in the next few months and we don't want dbo's having the ability to do this just yet.
January 15, 2016 at 3:07 am
Not if they're dbo. You can't deny much to someone at that level. Instead you'd need to grant them individually each of the dbo level permissions, but not allow them to ALTER database since that's the one that gives them that permission.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy