MSDE - Setting up security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jan F (JanF_at_discussions.microsoft.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 14:20:53 -0700

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.

Relevant Pages

  • Re: speech recognition & e-mail messages probs !!!
    ... Thanks for all your solid advice Grant and Mark, ... All of your recent posts are noted. ... I _think_ Dragon has commands something like: ...
    (microsoft.public.windows.vista.general)
  • Re: BSM, SSH, and Session ID
    ... I don't think writing a 'script' to monitor anything at all for that purpose, is going to be ingenius enough to really matter. ... I would use it to track any basic commands like mv, cp, rm, scp, sftp, unlink. ... As long as you allow someone to login and run any arbitrary commands, they have the potential to avoid any logging or tracking you may set up. ... 'exec' events with that session ID and run as root. ...
    (Focus-SUN)
  • Re: [opensuse] mv and cpio have new behavior. How do I get the old back?
    ... What I need is a quick cursory date/time. ... my build account or run the tools. ... detail it is easier to login. ... For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx ...
    (SuSE)
  • Re: [SLE] Login problems
    ... The only way I can login is on the console is as ... > said package telnetd will be installed and then when I clicked ok it ... Then while still in your user account start your GUI by running the ... For additional commands send e-mail to suse-linux-e-help@suse.com ...
    (SuSE)
  • RE: Best practices for implementing Cisco ACS?
    ... Create a group and give it Priv 15. ... Then grant the specific ... commands that you wish that group to have and end the list with a deny ... that to be the most effective way to control what commands a group can ...
    (Security-Basics)