SQL Server Schema only visible to a single user

Steve Hogg
Steve Hogg used Ask the Experts™
on
I want to create a schema that will only be visible and accessible by one user. Currently we about 50 users and 20 schemas in the database, I don't want to touch those users are schemas. In other words, only this one user will be able to see the schema and objects in that schema.

How can I do this with the least amount of effort.

Thanks for you help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
then follow these steps:

1. Create this schema with AUTHORIZATION option so that this user alone contains full privileges in this schema.
2. Grant permissions of objects under this schema only to the required users.

Note: db_owners and sa privilege accounts can view your new schema as they have privileges at the database and server level and doing the above would limit the restricted users alone not able to modify your schema..
Thanks!
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial