MSDE - Setting up security

I am just missing the big picture. I am having some problems that I think I
can correct by entering sp_grantlogin to grant a login to the SQL Server and
sp_adduser to add a user to the database.
I have no idea where these commands go. What tool/process am I using to get
the commands into MSDE to change the security? I tried cranking up OSSQL but
it just kept showing me the list of commands.
Sorry to be dumb.
Jan F wrote:
> I am just missing the big picture. I am having some problems that I
> think I can correct by entering sp_grantlogin to grant a login to the
> SQL Server and sp_adduser to add a user to the database.
> I have no idea where these commands go. What tool/process am I using
> to get the commands into MSDE to change the security? I tried
> cranking up OSSQL but it just kept showing me the list of commands.
> Sorry to be dumb.
You can use OSQL's command-line interface. The MSDE does not include the
SQL Server Client Tools, but you can use the web data administrator or
any third-party management tool:
http://www.microsoft.com/downloads/d...displaylang=en
David G.
|||Hi Jan,
There's a tool at our site (MSDE Manager) that's free for personal use.
It'll help you do all these sorts of things.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jan F" <JanF@.discussions.microsoft.com> wrote in message
news:7F184178-D650-4B0B-9BD1-A1DE4C12FD44@.microsoft.com...
>I am just missing the big picture. I am having some problems that I think I
> can correct by entering sp_grantlogin to grant a login to the SQL Server
> and
> sp_adduser to add a user to the database.
> I have no idea where these commands go. What tool/process am I using to
> get
> the commands into MSDE to change the security? I tried cranking up OSSQL
> but
> it just kept showing me the list of commands.
> Sorry to be dumb.
>