Re: How to create a user in MSDE?



Hi Terry ! :O)

Look at the sp_grantdbaccess stored procedure
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ga-gz_290z.asp

--
Best Regards
Yanick
"Terry Olsen" <tolsen64@xxxxxxxxxxx> a écrit dans le message de
news:%23GNgp9cdFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
> I need to know how to create a user in MSDE. I can't seem to get the
> syntax correct. I've tried several different variations such as the
> following, but nothing seems to work.
>
> CREATE USER user PASSWORD password
> CREATE USER 'user' PASSWORD 'password'
> CREATE USER user PASSWORD 'password'
> CREATE USER user SET PASSWORD 'password'
>
> Can't seem to find any references on google either. Can anyone help?
>
> *** Sent via Developersdex http://www.developersdex.com ***


.



Relevant Pages

  • Re: Stored Procedure in SQL Server vs MSDE 2005 SQL Server
    ... Sylvain Lafontaine, ing. ... converted to MSDE 2005 SQL Server Express. ... The stored procedure in the SQL server is called BOM2ECO_Difference_Get. ...
    (microsoft.public.access.externaldata)
  • Re: Stored Procedure in SQL Server vs MSDE 2005 SQL Server
    ... converted to MSDE 2005 SQL Server Express. ... Set cmd = cat.Procedures.Command ... The stored procedure in the SQL server is called BOM2ECO_Difference_Get. ...
    (microsoft.public.access.externaldata)
  • Re: MSDE and ODBC Tables
    ... You can create a stored procedure or a script that performs DELETE FROM ... > Is there an example of how I could do this just using scripts and MSDE ... It looks like I have the agent still in MSDE to ...
    (microsoft.public.sqlserver.programming)
  • Setting up VS.NET to debug MSDE stored proocedures. URGENT PLEASE HELP
    ... I read different articles about setting up VS.NET 2003 to debug MSDE ... I did exactly the same (copied MSSDI98.dll to binn ... folder of MSDE), and gave sp_sdidebug exec permission, but i am not ... ExecuteReader to invoke the stored procedure. ...
    (microsoft.public.vsnet.debugging)
  • Re: Inserting Nulls into a Dataset
    ... Think your reply got lost. ... to null using the SetNull method. ... stored procedure. ... Regards ...
    (microsoft.public.dotnet.framework.adonet)