A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello, how would I go about granting a particular User within a DB to create/modify/drop/read (& same DMLs) their own new Tables only but Read-only access to existing Tables?
Something along the lines of Schema and db_datareader role or something else?
Thanks in advance.
For granting permissions, you can also refer to this official document.
If the following answer solves your problem, please accept it generously.