SQL2000 UserPermissions for Database
- From: "Arejan" <areejan2000@xxxxxxxxx>
- Date: 3 Dec 2006 12:42:36 -0800
there are 5 databses in sql server.
created a user Userx
and set the dataccess for databaseA and databaseF as follows
public
db_backupoperator
db_datread
db_datawrite
(the user can only edit del add and backup records/tables)
1.whats the command to select only databases whose user is "Userx"
2.how to restore the windows group builtin\administrator once deleted
VB6 Qstion
3. Sqldmo and SQLDMO.RegisteredServer needs client tools to be
installed in a PC in lan ?
are there any dlls that can be included to run SqlDmo?
.
- Follow-Ups:
- Re: SQL2000 UserPermissions for Database
- From: Uri Dimant
- Re: SQL2000 UserPermissions for Database
- Prev by Date: Re: AUDIT all commands performed by Privileged Users on SQL 2000/2005
- Next by Date: Re: SQL2000 UserPermissions for Database
- Previous by thread: Re: AUDIT all commands performed by Privileged Users on SQL 2000/2005
- Next by thread: Re: SQL2000 UserPermissions for Database
- Index(es):