- Connect to sqlplus: sqlplus => system => password1 OR sqlplus system/password1@sonlmdb
- Show current user: show user;
- Show current database: select * from global_name;
- OR select instance_name from v$instance;
- Create user: create user
identified by ; - Grant permission for user: grant connect,resource to
;
Tuesday, April 19, 2011
Oracle SQLPlus
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment