Post reply

Login Issue::

  • April 19, 2006 at 6:29 am

    #152917

    Hi,

    I have Created a new login for a database and i want that when i login  into Query Analyser with this login , i also want that Master and Tempdb databases should not be access to that login.

    I have also set a particular Database to this login but it also shows Master and tEmpdb databases.

    How can i do this ??????

    Regards,

    Amit

     

     

  • April 20, 2006 at 10:09 am

    #633312

    Hi Guys!!

    You have any answer for this.

    I want to create a user which can access only a particular  Database and also i don't want to permit such user to access the Master & Tempdb Database.

    Please provide a Quick solution for it.

    Regards,

    Amit Gupta

     

  • April 20, 2006 at 12:57 pm

    #633360

    The short answer is you can't deny access to Master and Tempdb to a login.  Both databases have the Guest user and Public role, neither of which can be removed.  However, if you look at the permissions granted to Public, you'll see that it only has SELECT permission.

    Greg

     

    Greg

  • April 21, 2006 at 2:35 am

    #633426

    Thanks for your answer,Greg.

    I know this thing, which you are saying,

    but if you purchase a space to host a site,they will create a database of a particular name and you have permission to work only that particular database.

    You do not have any choice to change the database.

    I want to implement such thing. How will it possible ??. Pls suggest to me what to do regarding, this scenario...

    Regards,

    Amit Gupta..

     

  • April 21, 2006 at 10:58 am

    #633571

    They can't deny access to tempdb because that would kill off any temporary tables you might try to use. Master is required too because there are two objects within master you must have access to. If they are restricting access it is by deploying a client that only allows you to switch database context to your configured databases. There are web-based applications which do this.

    K. Brian Kelley
    @kbriankelley

  • April 24, 2006 at 3:09 am

    #633715

    Thanks for replaying,

    but there is any way to hide master and tempdb databases,so that when a user login into his user name & password to Query Analyser.

    It will show only a particular given Database and rest will hide

    Regards,

    Amit Gupta

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

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