null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
3770170
Administración de usuarios y mantenimiento de bases de datos
Description
Selectividad Taller de Administración de Bases de Datos Mind Map on Administración de usuarios y mantenimiento de bases de datos, created by Ernesto Davalos on 14/10/2015.
No tags specified
taller de administración de bases de datos
selectividad
Mind Map by
Ernesto Davalos
, updated more than 1 year ago
More
Less
Created by
Ernesto Davalos
over 8 years ago
13
0
3
Resource summary
Administración de usuarios y mantenimiento de bases de datos
CREATE LOGIN "Crear usuario"
WITH PASSWORD = "asignar Contraseña"
ALTER USER "Modificar usuario"
WITH "NOMBRE DEL CAMPO" = "PARAMETRO"
DROP USER user_name "Eliminar usuario"
RESPALDO
BACKUP DATABASE = "nombre de la base de datos"
TO DISK = "Direccion donde se almacenara"
WITH FORMAT "formato"
MEDIANAME =" Nombre"
NAME =" Nombre del archivo"
REORGANIZAR INDICE
ALTER INDEX ALL ON "Nombre de la base de datos"
REORGANIZE ;
REDUCIR BD
DBCC SHRINKDATABASE (BASE DE DATOS PORCENTAJE)
LIMPIAR HISTORIAL
Grupos
CREATE ROLE [ ]
ALTER AUTHORIZATION ON SHCHEMA::[BD] TO [ Rol ]
GRANT INSERT ON [ BD] TO [ROL]
GRANT DELETE ON [BD] TO [ROL]
GRANT SELECT ON [BD ] TO [ROL]
GRANT UPDATE ON [BD] TO [ROL]
Media attachments
01c850fb-998a-4086-b81d-77072a12bfdd (image/jpg)
5d347878-8802-407b-8e25-2e8d97f6ad70 (image/jpg)
1aa48a14-952a-490e-b524-9800fda24f0c (image/jpg)
2991ff26-2bbd-4647-bb74-6819a45fdf49 (image/jpg)
2ccca003-91eb-49d2-b3e3-308db06a87df (image/jpg)
d2d31715-e96a-40d9-a667-5c5c380ecb05 (image/jpg)
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Transacciones bases de datos
Manuel Vergara
Study Plan
mlanders
Harry Potter Trivia Quiz
Andrea Leyden
A-Level Chemistry: Atomic Structure
cian.buckley+1
Devices That Create Tension.
SamRowley
LOGARITHMS
pelumi opabisi
English Poetry Key Words
Oliviax
Peace and Conflict Flashcards - Edexcel GCSE Religious Studies Unit 8
nicolalennon12
How the European Union Works
Sarah Egan
1PR101 2.test - Část 5.
Nikola Truong
The Gastrointestinal System- Physiology- PMU
Med Student
Browse Library