MSSQL Revoke modification rights sysadmin

0

Is there a way in MSSQL to achieve following.

  • User X can perform only CRUD operations on DB1
  • User X can Backup DB1 and Resotre it as DB2
  • User X can perform any operation on restored DB2

Zdenek

Posted 2019-11-22T13:53:33.210

Reputation: 1

No answers

Asked: 2019-11-22T13:53:33.210

Viewed: 7 times

Active: 2019-11-22T13:53:33.210