Assign a read permission on a table in SQL Managed Instance

pozlu0 216 Reputation points
2022-11-18T20:17:39.46+00:00

Good evening,
I would like to know if it s possible assign a permission on a SQL table on SQL Managed Instance.
On premise I used to accomplish the task using the gui ,

Kind regards

Azure SQL Database
{count} votes

3 answers

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee
    2022-11-18T22:55:03.81+00:00

    Hi @pozlu0 Thanks for the question and using the Microsoft Q&A platform.
    If I understand correctly you want to know if it s possible to assign permission on a SQL table on an SQL Managed Instance
    Yes, you should be able to grant or deny object-level permissions. You could take a look here GRANT Object Permissions (Transact-SQL) - SQL Server | Microsoft Learn

    General permissions information for the Engine is here Permissions (Database Engine) - SQL Server | Microsoft Learn

    Regards
    Geetha

    0 comments No comments

  2. Alberto Morillo 34,146 Reputation points MVP
    2022-11-18T23:42:20.307+00:00

    Adding to @GeethaThatipatri-MSFT you can use T-SQL and a statement like the following:

    GRANT SELECT ON DBNAME.TABLE_NAME TO USERNAME  
    
    0 comments No comments

  3. pozlu0 216 Reputation points
    2022-11-19T08:36:02.28+00:00

    Thanks both of you guys for the valuable help.
    Kind regards


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.