Home Forums SQL Server 2008 Security (SS2K8) How to create a login with default database role "db_datareader" RE: How to create a login with default database role "db_datareader"

  • It seems like you want to create a user that should only see the databases on the server it has access to. This is unfortunately not possible. You can make the user owner of the database, but as the owner the user can do anything in the database.

    The user will need to learn to say "USE mydb".

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]