New Activity
Play Fill in the Blanks Game
- Crear y eliminar login , user y role
create login ____________________ with ____________________ = '1234'
create ____________________ ____________________ for login nombreLogin
drop ____________________ nombreLogin ;
____________________ user nombreUsuario ;
create ____________________ [ nombreRol ]
drop role [ ____________________ ]

- Permisos
____________________ all on [ dbo ] . [ ____________________ ] to [ ____________________ ]
grant ____________________ on schema : : [ ____________________ ] to [ nombreRol ]
revoke all ____________________ [ dbo ] . [ ____________________ ] to [ nombreRol ] ;
deny ____________________ on ____________________ : : [ dbo ] to [ nombreRol ] ;

- Dar rol
alter ____________________ [ ____________________ ] add member ____________________