Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
22 Cards in this Set
- Front
- Back
|
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'
|
