SQLTeam.com | Weblogs | Forums

Permission to a specific table


#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:


#4

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