Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Criar Tags */
- ALTER USER SYSDBA SET tags (T1='Valor 1', T2='Valor 2');
- commit WORK;
- /* Ver o conteúdo das tags */
- SELECT
- U.SEC$USER_NAME,
- A.SEC$KEY,
- A.SEC$VALUE
- FROM SEC$USERS U LEFT JOIN SEC$USER_ATTRIBUTES A ON U.SEC$USER_NAME = A.SEC$USER_NAME
- /* Remover Tags */
- ALTER USER SYSDBA SET tags (DROP T1);
- ALTER USER SYSDBA SET tags (DROP T2);
- commit WORK;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement