Permission to a specific table

Transact-SQL
1

In SQL, I know how to give permission to an access database, but I am not sure how to give just one user permissions to a specific table.

Database is IMPACT
the table is called P10

Thanks in advance.

2 
USE IMPACT;
GRANT SELECT ON dbo.P10 TO RosaQdM;
GO

More details here.
You can also do this using SSMS. Right-click on the table name, then Properties->Permissions

3

Blimey! that's impressive, how did you know the User ID? :innocent:

1 Like
4

Tapping on the side of my forehead with my index finger
It's all up here Kristen, I am omniscient :smile: :smile: :smile:

2 Likes