September 14, 2015 at 10:20 am
Im getting a bit confused implementing my schemas.
i have 3 ssis archive packages (one for each department) that connect to a few source db's pull data down into an archive database. In the source db's i have created a 'DataArchive' schema and a login for each package, so each package connect with its own login. I was wanting to control the security of the logins from within the schema but to get my sql to run i still have to assign permissions to the actual users ie. select permissions for tables they can query. Am i using schemas wrong? are they more for just keep objects together?
im not using roles, possibly is this a missing step?
Thanks,
September 14, 2015 at 2:25 pm
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]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply