grant privileges to user in oracle 11g

Monday August 4 17:54:06 2014Copyright (c) 1982, +, Oracle. All rights reserved.ERROR:Ora-01017:invalid Username/password; Logon deniedPlease enter user name: C:\Documents and Settings\guogang>sqlplus Gg_test/gg_test@10.10.15.25_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 17:52:35 2014Copyright (c) 1982, +, Oracle. All rights reserved.Connect to

1. After logging on to Oracle, enter the following command: [Oracle @ localhost ~] $ Vi. bash_profile 2. Add from # huzia. #. Bash_profile # Get the aliases and functions If [-f ~ /. Bashrc]; then .~ /. Bashrc Fi # User specific environment and startup programs PATH= $ PATH: $ HOME/bin Export PATH # Huzia 2011.08.28 #

Today, I heard colleagues talk about the Oracle password expiration, only to remember that the Oracle 11g Default user password is valid for 180 days, Oracle 10g Default User password is life.

Label:Sql> create Pfile from SPFile;Modify the Pfile file, add the implied parameter *._enable_rename_user= ' TRUE ' to start the database in restrict mode1, [[email protected] ~]$ cd/u01/app/oracle/product/11.2.0/db1/dbs/2, [[email protected] dbs]$ lsHc_yoon.dat Init.ora inityoon.ora lkyoon orapwyoon snapcf_yoon.f Spfileyoon.ora3, [[email protected] dbs]$ TAIL-1 Initnode1.ora namely: VI Inityoon.oraAdd to*._enable_rename_user= ' TRUE '4, sql> startup

Tags: sys system SYSDBA Sysoper1,oracle Default user name, passwordUsername/Password Login identity (role) descriptionSys/change_on_install SYSDBA, Sysoper cannot log in as NORMALSystem/manager NORMAL cannot log in with SYSDBA, SysoperScott/tiger Normal Normal User2, user sys and system Sys : sysdba(System administrator) Sysoper(System Operator) dba(Database Ad