QUERY: 1 SQL Server restricted access according to user account... -- sql server new users

Arnie Rowland
12/20/2006 10:48:25 AM

Not in SQL 2000, but very 'doable' in SQL 2005.

Read up on using 'Schemas' in Books Online.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]

Andrew Wan
12/20/2006 5:22:09 PM

Is it possible to run only 1 SQL Server 2000/2005 and set it up so that it
displays specific databases corresponding to the user account logged in?

sql server new users : QUERY: 1 SQL Server restricted access according to user account...