I need to create new user logins that can only get data from a specific
database. I am using the "Create Login" command to do this. Right now, I
am
working with SQL Server EXPRESS 2005
CREATE LOGIN TestLogin
WITH PASSWORD = 'password',
DEFAULT_DATABASE = TestDB,
CHECK_EXPIRATION = OFF,
CHECK_POLICY = OFF
This works, as it does create the login. However, when I try to actually
connect with this new login, I receive an error that it can't open the
default database. If i connect as the SA, and go to the "User Mapping"
for
the new login (in this case "TestLogin"), no databases are checked. If I
check this login's default database (in this case "TestDB"), then I am
able
to re-connect as the new login ("TestLogin") and am able to get data from
the
default database ("TestDB").
Can someone explain what I am missing to programatically create this
login,
assign a default database and have it work?
Thank you
MATT
Re: PDO: Switch database user without reopening connection ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ... (comp.lang.php)
Re: PDO: Switch database user without reopening connection ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... (comp.lang.php)
RE: How to allow users to change their password? ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first.... See http://www.QBuilt.com for all your database needs.... (microsoft.public.access.security)
Re: Please! Doesnt anyone know a better way to do this? ...account, they need to automatically be directed to the page to enter data ...session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ... (microsoft.public.dotnet.framework.aspnet)
Re: Enter user name, enter password, then press enter... ... What do you do when the customer asks that the database login in be the same ...username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ... (microsoft.public.access.forms)
