Re: SQL2000 UserPermissions for Database

Arejan
1.whats the command to select only databases whose user is "Userx"

EXEC sp_grantdbaccess 'Login', 'Userx'

2.how to restore the windows group builtin\administrator once deleted

Type BUILTIN/Administrators in the NAME text box

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?


It is library to work against SQL Server from the client side. Yes




"Arejan" <areejan2000@xxxxxxxxx> wrote in message
news:1165178556.581889.74120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: SQL2000 UserPermissions for Database
    ... SQL Server MVP ... "Arejan" wrote in message ... I need to populate a combobox for login for userx which will get this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2000 UserPermissions for Database
    ... I need to populate a combobox for login for userx which will get this ... select database from sysobjects where username ='userx'? ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2000 UserPermissions for Database
    ... its EXEC sp_grantdbaccess 'Userx' ... set the dataccess for databaseA and databaseF ... select all databases that "Userx" can access. ...
    (microsoft.public.sqlserver.security)