Re: SQL2000 UserPermissions for Database

Dan

SELECT name
FROM master.dbo.sysdatabases
WHERE HAS_DBACCESS(name) = 1
ORDER BY name

gives a list of all databases

databaseA
databaseB
databaseC
databaseD
databaseE
databaseF
master
model
pubs
....

( log in as sa (administrator))

i want to show only 2 databases of which Userx has previlage to login


Database user
databaseA Userx
databaseF Userx

as other databses are not used in this context

is there an select query for this?

.

Relevant Pages

  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: Move Existing SQL Server to a New Server
    ... Restore master, then model, then msdb then the user ... databases during start up ... I do not want to move all user databases, ... > moving or restoring the databases - especially related to ...
    (microsoft.public.sqlserver.setup)
  • Re: Move Existing SQL Server to a New Server
    ... To move the master, you need to use the start up parameters ... If you are restoring the original master database, ... user databases. ... >simple volume in the OS and a C and E partition. ...
    (microsoft.public.sqlserver.setup)