Hi,
Created SQL Login
- I have provide "Public" & "Securityadmin" at server level privileges.
- I have provide “db_accessadmin” & “db_datareader” & “db_securityadmin” & “public” at database level privileges.
- Then go with “SQL Login”.
- Expand database- then expand tables - and select table & select properties.
- In “select page” popup-window go to “Permissions” tab select “search” then select “Browse”. here select “User” OK OK
- Here I choose “Select” with “deny” option. OK
- In query window “USE AdventureWorks2012” GO
- Then select * from HumanResources.Department
- But here display results…
- Not comes error message…
What are the options need to select at "Server level & DB Level", for this security..? why it is not working still..?