Assign a read permission on a table in SQL Managed Instance

Question

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

Answer 1

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

Answer 2

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

GRANT SELECT ON DBNAME.TABLE_NAME TO USERNAME  

Answer 3

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