Beginner security questions

From: Jack Wachtler (jack_wachtler_at_comcast.net)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 12:56:10 -0800

Thanks in advance for your patience with my beginner questions.

I have a SQL Server instance setup on my XP desktop (the 120 day Evaluation Edition - V8.00.194). When I installed it I setup the instance with "Windows Only" authentication.

I have myself and my wife with XP user accounts and also have a guest user account active. I created a database for practice, and would like allow either my wife's account or the guest account to login and access the one practice database, with select priviledge's only on tables. Ideally from these "user" XP accounts, I would like to allow access to my practice database only through the Query Analyzer Window. I don't want to allow these accounts to see other databases or system tables. I don't want them to be able to stratup Enterprise Manager or any tool other than Query Analyzer for the one database.

What are the steps I need to follow to create permissions? After I do these steps, I want to log in through the guest account and see that my security setup works.

I have read the chapters in my textbook on security, but still don't really get it. I guess I need a simpler example that I can practice for myself.

Your help in teaching a newbie is greatly appreciated.

Relevant Pages

  • Re: Re: Re: Questions about Trusts
    ... want your security setup. ... which therefore keeps the security in tact. ... Remember that you won’t have any data loss as long as you back it up ... The worst scenario is that the permissions will ...
    (microsoft.public.win2000.active_directory)
  • Re: Secured Database works exactly right on one computer, but on another not quite r
    ... It's nothing to do with "security setup and permissions". ... She obviously has different mdw's being implemented on different machines. ... (well, as I see it, 50% chance of being wrong as usual!) ...
    (microsoft.public.access.security)
  • Re: 2nd User Cant Open db on LAN
    ... Both of these users have RW permissions on that directory ... I'm looking into the server's security setup, ... so headway doesn't come easy. ...
    (microsoft.public.access.security)