-
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
____________________