Re: Script A Login

Hi
http://dimantdatabasesolutions.blogspot.com/2007/04/sql-or-windows-authentication.html




"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:313F8DB1-3495-4050-9CA7-714255738EB9@xxxxxxxxxxxxxxxx
Hi.

I am crrently running SQL Server 2005, I have an Excel VBA application
that
exacutes a number of stored procedures against the database, this database
is
restored every evening so needs a login created on it every time the
restore
job runs. I believe the script should look a little like this for
creating a
Login and User

USE [Database]
CREATE LOGIN ExcelKPI WITH password='ExcelKPI',
Default_Database = [Database]
CREATE USER ExcelKPI FOR LOGIN ExcelKPI
WITH DEFAULT_SCHEMA=dbo_owner

And then I need to Grant necessary permissions, e.g. Insert & Update

It runs fine and creates the logins but still doesn't work, I have to then
go to the main security tab and give the login Sysadmin rights to get it
to
work which I am sure shouldn't be necessary, I am probably just not
setting
it up correctly.

Could anyone offer some advice.

Thanks P


.

Relevant Pages

  • 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)