SQL Server Management Studio User to Access Certain Database

Berikut adalah cara supaya user hanya bisa melihat database tertentu, tidak semua database yang terdapat pada server

1. Create user account

2. Right Click on the upper section of the SQL (SQLSERVER Name)>Properties>Permissions>Click on the user account, and select Deny to view databases

3. Right Click on the newly created DB, Properties,Files, and change the Owner to the newly created account

Coba login dengan user baru tersebut

http://stackoverflow.com/questions/935018/hide-sql-database-from-management-studio

Chandra Oemaryadi has written 244 articles

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>