RE: [Emerald] SQL 7.0 and security

Brian Johnson ( (no email) )
Tue, 7 Dec 1999 12:00:06 -0600

OK, then why when I delete a user in the Emerald Admin, the user is still
listed in the Operators list. I closed Emerald Admin and re-opened it and
the user is still there. When I try to delete it again, i get the following
error:

SQL Server Error: 15008 User 'billybob' does not exist in the current
database.
State= 1, Severity= 16

When I use Access and look in the Operators table, the user billybob is
still there. Also when I go into the Enterprise manager, the user billybob
is still listed.

Is this normal, and how should I deal with it?

Brian 8^(

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Tuesday, December 07, 1999 11:49 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] SQL 7.0 and security

Brian Johnson wrote:
>
> I know that you need to use Standard Security. I have SQL 7.0 and there
is
> no option for Standard Security for the server.
>
> What do I do now? 8^|

SQL 7 changed the security model. AS long as you don't use the
Windows NT Accounts only, you are fine (the default is equivalent
to standard).

--

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart



For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart