Re: permissions for Desktop engine

From: Cedric Zaugg (czaugg@aesa.ch)
Date: 06/06/02 

From: "Cedric Zaugg" <czaugg@aesa.ch>
Date: Thu, 6 Jun 2002 15:57:56 +0200

Thanks a lot for your help

Cedric

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:eoEiGtVDCHA.1560@tkmsftngp02...
> You can setup security with system stored procedures and execute these
> with the OSQL utility or any ad-hoc SQL application. The basic steps
> are to add the login to SQL Server, grant database access and role
> membership (optional). Below are some untested examples. See the Books
> Online for details.
>
>
> --add SQL Authentication login
> EXEC sp_addlogin 'MyLogin', 'MyPassword'
> EXEC sp_defaultdb 'MyLogin', 'MyDatabase'
>
> --add Windows Authentication login (existing Windows user)
> EXEC sp_grantlogin 'MyDomain\MyLogin'
> EXEC sp_defaultdb 'MyDomain\MyLogin', 'MyDatabase'
>
> USE MyDatabase
>
> --setup object permissions
> EXEC sp_addrole 'MyRole'
> GRANT ALL ON MyTable TO MyRole
>
> --grant database access
> EXEC sp_grantdbaccess 'MyLogin'
> EXEC sp_grantdbaccess 'MyDomain\MyLogin'
>
> --add role membership
> EXEC sp_addrolemember 'MyRole', 'MyLogin'
> EXEC sp_addrolemember 'MyRole', 'MyDomain\MyLogin'
>
>
> --
> Hope this helps.
>
>
> Dan Guzman
> SQL Server MVP
>
> -----------------------
> SQL FAQ links (courtesy Neil Pike):
>
> http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> http://www.sqlserverfaq.com
> http://www.mssqlserver.com/faq
> -----------------------
>
> "Cedric Zaugg" <czaugg@aesa.ch> wrote in message
> news:adn6li$h4v$1@rex.ip-plus.net...
> > Hi,
> >
> > How can I setup usernames and passwords for the Desktop engine without
> > having the Entreprise Manager installed?
> >
> > Thanks,
> > Cedric
> >
> >
>
>

Relevant Pages

  • Re: permissions for Desktop engine
    ... with the OSQL utility or any ad-hoc SQL application. ... EXEC sp_defaultdb 'MyLogin', 'MyDatabase' ... GRANT ALL ON MyTable TO MyRole ...
    (microsoft.public.sqlserver.security)
  • Re: Full text catalog just not populating
    ... exec sp_defaultdb N'NT Authority\System', N'master' ... means either the network guys in my company who don't know SQL but are admins ... > needs this login to log into SQL Server and you can either add back this ... >> fetching U ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexing delay for one row.
    ... script and WAITFOR and varying the delay from 1 to 18 seconds. ... could you confirm your exact version of SQL Server that you are seeing ... It is possible that a change was made to the pooling frequence under SP3 to ... exec sp_fulltext_table 'FTSTable','create','FTSCatalog','FTSTable_IDX' ...
    (microsoft.public.sqlserver.fulltext)
  • Re: storing and searching office docs in SQL
    ... You CAN both store and search the contents of the MS Word ... files stored in an SQL Table's FT-enable IMAGE column, ... FTS CONTAINS or FREETEXT to search the contents of that MS word document: ... exec sp_fulltext_database 'enable' -- only do this once! ...
    (microsoft.public.sqlserver.programming)
  • Re: SqlDataAdapter1.SelectCommand.CommandType= CommandType.StoredProcedure
    ... > kann man beim EXEC PROC keine Parameter beifügen. ... CommandType.StoredProcedure wird intern als RPC Command abgesetzt, ... SQL RPC siehe SQL Server Dokumentation, ... nach der Ausführung ungültig werden. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)