Home Forums SQL Server 2008 Security (SS2K8) Using schemas effectivley RE: Using schemas effectivley
Erland Sommarskog
SSC-Insane
Points: 24038
More actions
September 14, 2015 at 2:25 pm
#1826551
It is unclear what you did, but you can grant permissions on schema level. For instance:
GRANT SELECT ON SCHEMA::DataArchive TO someuser
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]