Differences

This shows you the differences between two versions of the page.

--- informatica:oracle:comandos [2015/08/03 14:55] – jose
+++ informatica:oracle:comandos [2024/06/19 09:46] (current) – jose
@@ Line 1: / Line 1: @@
-Comprobar usuario bloqueado:
+<code>
+SELECT 'DROP TABLE ' || owner || '.' || table_name || ' CASCADE CONSTRAINTS;' AS drop_command
+FROM all_tables
+WHERE owner = 'WZC_AUTHORIZATION_OWN';
+</code>
+<code>
+set sqlformat insert;
+select * from WZC_AUTHORIZATION_OWN.AUTHORIZATION_CONFIGURATION;
+set sqlformat default;
+</code>
+====== Crear Usuario ======
+  CREATE USER usuari IDENTIFIED BY contrasenya
+  GRANT CREATE SESSION TO usuari
+====== Comprobar usuario bloqueado: ======
 <code>
 select username,account_status,profile from dba_users where username='jose'