Answers for "oracle username"

SQL
4

oracle user tables

SELECT * FROM USER_TABLES;		-- Tables from connected schema
SELECT * FROM ALL_TABLES;		-- Tables available to connected schema
	SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
	SELECT * FROM ALL_TABLES WHERE TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All Tables
Posted by: Guest on January-31-2021
2

oracle sql create user

-- Oracle - User / schema creation
CREATE USER MY_USER IDENTIFIED BY "MyPassword"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO MY_USER;           -- To connect to DB
GRANT RESOURCE TO MY_USER;          -- Access / modify
GRANT MY_ROLE TO MY_USER;           -- Grants a role (to be defined)
ALTER USER MY_USER DEFAULT ROLE "RESOURCE","CONNECT","MY_ROLE";
-- Proxy access
ALTER USER MY_USER GRANT CONNECT THROUGH MY_OTHER_USER;
-- Checks privileges:
SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = MY_USER;
Posted by: Guest on January-20-2021

Code answers related to "oracle username"

Code answers related to "SQL"

Browse Popular Code Answers by Language