Post reply

Permission to view database

  • August 9, 2004 at 9:51 pm

    #85147

    Dear all,
    I have a got problem that:
    My DB server (msSQL 2K) has many users.
    Each user owner one database. How can I set up secure that user can only view owner database ?
     
    Thanks for advise !
     
     
     

  • August 10, 2004 at 7:44 am

    #518308

    Just give the user access to their own database and not any other database.

    In Enterprise Manager, drill down to Security, expand that and click on Logins. Find the Login that you want to check, and double click on it. Go to the Database Access tab. Make sure that only the database the user needs to access is checked.

    In Query Analyzer, just use the GRANT command.

    Refer to the BOL for more information about using GRANT.

    -SQLBill

    BOL=Books OnLine=Microsoft SQL Server's HELP

    Installed as part of the Client Tools

    Found at Start>Programs>Microsoft SQL Server>Books OnLine

     

  • August 13, 2004 at 9:30 pm

    #518992

    Hi SQLBill,

    I am sure know grant permission for each user by your suggest he/she can not access another db but can view nam db (list dbs on my server), but I want to that:

    when user connect my server by SQL Eneterprise, he/she can only view his/her DB not view list another db in DATABASES tab - You know that because if h/she can view list databases on my server he/she an know my server has many DB.

    Thanks for advise,

     

    Thanh Binh

  • August 18, 2004 at 8:18 am

    #519589

    You cannot do that. When you open SQL server, the databases are listed from Sysdatabases on which public user has select access.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply