Multiple users with the same default "schema"

Probably quite a simple one, have patience...I'm just learning the
ropes with SQL Server...
I want to grant new users access to an existing database, owned by
user X. So far this works, but user Y has to include X's username
before any object names. For example
select * from cd_collection;
does not work, Y has to use
select * from X.cd_collection;
instead. Any advice on how to add new users (with varying permissions)
to an existing "schema" so that they would have the schema as default
one? SQL Server version is 7.0.Hi
In SQL Server 7 or 2000 you can not change this.
Kalen Delaney wrote an article in the April SQL Server magazine " "Object
Ownership and Security" (InstantDoc ID 41773), I talked about the confusions
and limitations surrounding SQL Server 2000's model, which doesn't separate
the concepts of user and schema." This also talks about the changes in SQL
Server 2005 (Yukon).
http://www.winnetmag.com/SQLServer/...1773/41773.html
John
"janne" <janne_1976@.hotmail.com> wrote in message
news:6539de6f.0406142332.6de2004d@.posting.google.com...
> Probably quite a simple one, have patience...I'm just learning the
> ropes with SQL Server...
> I want to grant new users access to an existing database, owned by
> user X. So far this works, but user Y has to include X's username
> before any object names. For example
> select * from cd_collection;
> does not work, Y has to use
> select * from X.cd_collection;
> instead. Any advice on how to add new users (with varying permissions)
> to an existing "schema" so that they would have the schema as default
> one? SQL Server version is 7.0.

multiple SQL Servers on one server

I need to have a second instance of SQL Server 2000 put on a server and I'm
wondering if there is anything I need to do to the existing instance of SQL
Server so it will work fine with the second installation? Thanks.You may want to limit the amount of memory used by the first instance. =
Other than that, nothing really comes to mind.
--=20
Keith
"tanner" <anonymous@.discussions.microsoft.com> wrote in message =
news:1A132C7D-538F-4566-A0AE-22541E919802@.microsoft.com...
> I need to have a second instance of SQL Server 2000 put on a server =
and I'm wondering if there is anything I need to do to the existing =
instance of SQL Server so it will work fine with the second =
installation? Thanks.|||have you thought through the question of whether a new instance is needed,
or can you simply get by with additional db's. You may very well need a new
instance, but... I've seen a number of customers use new instances in cases
when multiple db's on the same server might have been well suited.
If you have security or mgmt reasons for splitting the instances then of
course it's probably a good idea...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"tanner" <anonymous@.discussions.microsoft.com> wrote in message
news:1A132C7D-538F-4566-A0AE-22541E919802@.microsoft.com...
> I need to have a second instance of SQL Server 2000 put on a server and
I'm wondering if there is anything I need to do to the existing instance of
SQL Server so it will work fine with the second installation? Thanks.