SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,681 questions
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,861
Reputation points
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.
{count} votes
-
PercyTang-MSFT 12,501 Reputation points Microsoft Vendor2023-03-15T02:03:58.6366667+00:00 For granting permissions, you can also refer to this official document.
If the following answer solves your problem, please accept it generously.
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more