Advertisement
Guest User

Untitled

a guest
Feb 19th, 2020
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. --ver qual e o(s) user(s) que nao estao criados ainda
  2. SELECT username FROM dba_users;
  3. --criar o user CARLOS pk e o que nao esta nao tabela
  4. CREATE USER CARLOS10700007 IDENTIFIED BY CARLOS10700007;
  5. --atualizar o campo username na tabela aluno para o CARLOS
  6. UPDATE aluno SET username='CARLOS10700007' WHERE bi=10700007;
  7. --verificar que o user foi criado
  8. CONNECT sys/sys AS sysdba;
  9. SELECT username FROM dba_users;
  10. --verificar que o username foi atualizado na tabela aluno
  11. SELECT * FROM REP_FICHA1.aluno;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement