Consultas En Oracle
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Consultas En Oracle as PDF for free.
More details
- Words: 61
- Pages: 3
EVALUACION DE CONSULTAS EN ORACLE
DROP USER CONSULTAS CASCADE;
CONNECT SYS/A AS SYSDBA; CREATE USER CONSULTAS IDENTIFIED BY A; GRANT CONNECT TO CONSULTAS; REVOKE CONNECT FROM CONSULTAS; ALTER USER CONSULTAS DEFAULT TABLESPACE USERS; GRANT DBA TO CONSULTAS;
PROMPT "CONSULTA 1" SELECT USERNAME
FROM DBA_USERS
PROMPT "CONSULTA 2" SELECT USERNAME OBJECT,USERNAME TYPE FROM DBA_USERS;
PROMPT "CONSULTA 3" SELECT USERNAME PASSWORD FROM DBA_USERS;
DROP USER CONSULTAS CASCADE;
CONNECT SYS/A AS SYSDBA; CREATE USER CONSULTAS IDENTIFIED BY A; GRANT CONNECT TO CONSULTAS; REVOKE CONNECT FROM CONSULTAS; ALTER USER CONSULTAS DEFAULT TABLESPACE USERS; GRANT DBA TO CONSULTAS;
PROMPT "CONSULTA 1" SELECT USERNAME
FROM DBA_USERS
PROMPT "CONSULTA 2" SELECT USERNAME OBJECT,USERNAME TYPE FROM DBA_USERS;
PROMPT "CONSULTA 3" SELECT USERNAME PASSWORD FROM DBA_USERS;
Related Documents
Consultas En Oracle
April 2020 12
Consultas En Access
April 2020 5
Consultas En Access
April 2020 8
Consultas En Clase.
November 2019 17
