oracle query to check all tables a user has select privilege to
Query to check all tables with select privileges assigned to a user in oracle.
sql
sqlplus error on XE ORA-12154: TNS: could not resolve the connect identifier specified
Make sure the password for SYS or SYSTEM does not contain special characters like @ or !
Tags