I used to grant SELECT, UPDATE and other authorities to individual users on TABLE level in DB2 on Mainframe.
Does SQL Server have a way to grant SELECT and other privileges on a table level?
Another question I have is, suppose an instance has 2 databases A and B.
If I create a user the user has PUBLIC role as default. He can read both A and B. What if I want the user to read only database B how can I do that?
I may be wrong in above statements. Please correct me if I am wrong.
Thank you for your unchanging support
View Complete Post