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?

Question

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?

techresearch7777777 1,326

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.

PercyTang-MSFT 2,921 Reputation points Microsoft Vendor

2023-03-15T02:03:58.6366667+00:00

Hi @techresearch7777777

For granting permissions, you can also refer to this official document.

https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?source=recommendations&view=sql-server-ver16

If the following answer solves your problem, please accept it generously.

PercyTang-MSFT 2,921 Reputation points Microsoft Vendor

2023-03-15T02:03:58.6366667+00:00

Hi @techresearch7777777

For granting permissions, you can also refer to this official document.

https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?source=recommendations&view=sql-server-ver16

If the following answer solves your problem, please accept it generously.

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?

Activity