70-228 10
Terms
undefined, object
copy deck
- What transact SQL statement returns info regarding all Win2K groups or a specified group in the current Database
- sp_helpntgroup ['name']
- What transact SQL statement returns info regarding all database roles or membership in a specified role in the current database?
- sp_helprolemember ['role']
- What transact SQL statement returns info for all users or a specified user in the current database including role memberships?
- sp_helpuser ['security_account']
- What transact SQL statement returns info on server roles and their members?
- sp_helpsrvrolemember ['role']
- What transact SQL statement returns info for all logins or a specified login including the database and role?
- sp_helplogins ['login']
-
What transact SQL statement adds a new user-defined database role in the current database?
Recommendation - ? -
sp_addrole 'role', 'owner'
- leave owner as dbo - What transact SQL statement drops a user-defined database role in the current database?
- sp_droprole 'role'
- What transact SQL statement drops a security account from a database role in the current database?
-
sp_droprolemember 'role',
'security_account' - What transact SQL statement adds a security account to a database role?
-
sp_addrolemember 'role',
'security_account' - What transact SQL statement changes the owner of a user database?
- sp_changedbowner 'login'
- What transact SQL statement adds a login as a user in the current database?
- sp_grantdbaccess 'login', 'name-in-db'
- What transact SQL statement removes a login as a user in the current database?
- sp_revokedbaccess 'name'
- What transact SQL statement drops a login as a member of a server role?
- sp_dropsrvrolemember 'login', 'role'
- What transact SQL statement adds a login to a server role?
- sp_addsrvrolemember 'login', 'role'
- What transact SQL statement adds or changes a password?
-
sp_password 'old_password',
'new_password', 'login' - What transact SQL statement drops a SQL Server login?
- sp_droplogin 'login'
- What transact SQL statement creates a new SQL Server login?
-
sp_addlogin 'login', ['password',
'database', 'language', 'sid',
'encryption_option' - What transact SQL statement changes the default language for a login?
- sp_defaultlanguage 'login'
- What transact SQL statement changes the default database for a login?
- sp_defaultdb 'login', 'database'
- What transact SQL statement prevents a windows 2000 user or group from connecting?
- sp_denylogin 'login'
- What transact SQL statement revokes the login entry from SQL Server for Win2K user or group?
-
sp_revokelogin 'login'
(Doesn't explicitly block access) - What transact SQL statement creates a login for a Win2K user or group?
- sp_grantlogin 'login'