oracle database grant user privileges

)Change Password: Alter user username identified by modified passwordYou can also create your own roles:Syntax: Create role name;Example: Create role testrole;Authorization role:Syntax: Grant select on the class to role name;In the following: Grant Select on class to TestRole;Note: Now, all users with the TestRole role have select query permissions on the class t

Label:View the number of connections to the Oracle database and the user11. Query the number of connections to Oracle2select Count (*) from v$session;32. Querying the number of concurrent connections for Oracle4select Count (*) from v$session where status= ' ACTIVE ';53. View the number of connections for different users6select Username,count (username) from V$session where username are not null GROUP by us

database has a system tablespace that is created automatically during database creation or database installation, data dictionary tables for storage systems, program system units, process functions, packages, and triggers, and can also be used to store user data tables and indexed objects. Tablespaces have online and

the latest transaction processing. The restored block is generated throughout the process. This is called roll-forward or cache restoration. 3. At this time, the restored data file contains submitted and uncommitted changes. 4. Restore blocks are used to roll back any uncommitted changes. It is also called transaction recovery. 5. At this time, the data file is in the restored State and consistent with other data files in the database. --------------

0Job_queue_processes Integer 10Log_archive_max_processes Integer 2Processes integer 450Sql>Concurrency refers to active,i seeSql> Select COUNT (*) from V$session #连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Show parameter Processes #最大连接Sql> alter system SET processes = value scope = spfile; Restart database #修改连接Unix 1 user session corresponds to an operating system process

Before Oracle 10 Gb, when we connect to the database in SHELL or JDBC, we need to enter the user name and password, and both are in plain text. Starting from 1OGR2, ORACLE provides the wallet tool to log on to the database without entering the

Sqlplus /as SYSDBA --View DBF storage locationSELECT * from Dba_data_files; --View File location SELECT * from Dba_directories;--New Table spaceCreate tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf ' size 100m autoextend on next 50m maxsize 2 00m extent management Local;--New userCreate user bp_oracle identified by bp_oracle default Tablespace bp_oracle;--User AuthorizationGrant C

open state, use the alter database backup controlfile to trace command to back up the control file to the trace file Two methods are available to control file recovery. 1) Use recover database using backup controlfile in the mount status 2) in the mount status, the trace file is generated and restored. 2-2 example: [Oracle @ localhost ~] $ Rlsqlplus/as sy

Error: [Oracle@www.bkjia.com data] $ exp "sys/oracle@www.bkjia.com as sysdba" file =/data/sys. dmp log =/data/sys. log full = y;LRM-00108: invalid positional parameter value 'as' EXP-00019: failed to process parameters, type 'exp HELP = y' for helpEXP-00000: Export terminated unsuccessfully Cause:This may be a BUG of Oracle10g. You only need to follow the following two methods: Solution: Method 1:[

To test the role of database roles, use the set role command to enable roles, setting the default role for database users Create corner R1 and R2, where R2 password authentication, I set the password is Oracle Sql> Conn System/oracle Connected. sql> Create role R1; Role created. sql> Create role R2 identified by

If you want to install the sample user in Oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also create a database after installing the database software database.The original storage location of the sample file in linux: $ ORACLE_HO

Win+r Investigation Run window, enter CMD returnConnect to a local Oracle libraryCreate a tablespace named "SXSJ" with an initial size of 512M and support auto-scaling with 32M increments per increment;Create tablespace sxsj datafile ' D:\app\LZB\oradata\SXSJ ' size 512M autoextend on next 32M;Create a user named "SXSJ"CREATE USER SXSJ identified by SXSJ DEFAULT

/* Step 2: Log On */log on to PL/SQL with sys/sys Super User/* Step 2: create a temporary tablespace */create temporary tablespace user_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ Wu \ user_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 M extent management local;/* Step 4: create a data table space */create tablespace user_data logging datafile 'e: \

| | ' Allocate extent; ' from user_tables where num_rows = 0; Export:EXP user name/password @ip:sid/orcl file=/xxx/xxx/xx.dmp such as: Exp platform/[email PROTECTED]:1521/ORCL file=/data/oracle /platform_20180824.dmp; Import:imp username/password @ip:sid/orcl file=/xxx/xxx/xxx.dmp ignore=y full=y; such as: Imp platform/[email protected]:1521/orcl file=/data/

Label:What if we forget the user's password for the Oracle database and do not know the password of the user who is larger than the user's rights?Don't worry, as long as you have installed the database server operating system users, then you can easily solve, and the method described in this article is very general Oh

Create an oracle database, user, tablespace, and role permission setting script/* Divided into four steps *//* Step 2: create a temporary tablespace */Create temporary tablespace contract_tempTempfile 'd: \ oradata \ contract_temp.dbf'Size 50 mAutoextend onNext 50 m maxsize 20480 mExtent management local;/* Step 2: create a data table space */Create tablespace co

Label:/* divided into four steps *//* Step 1th: Create a temporary tablespace */Create temporary tablespace contract_tempTempfile ' D:\oradata\contract_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* Step 2nd: Create a data table space */Create Tablespace Contract_dataLoggingDataFile ' D:\oradata\contract_data.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* 3rd step: Create user and specify

Label: [sql] /*第1步：登录 */以sys/sys超级用户登录pl/sql /*第2步：创建临时表空间 */create temporary tablespace user_temp tempfile ‘E:\oracle\product\10.2.0\oradata\wu\user_temp.dbf‘size 50m autoextend on next 50m maxsize 20480m extent management local; /*第3步：创建数据表空间 */create tablespace user_data logging datafile ‘E:\oracle\product\10.2.0\oradata\wu\user_data.dbf‘size 50m autoextend onnext 50m maxsize 20480m extent manag

The method for starting Scott user in Oracle. In Oracle10g, (g stands for 'network') the Scott user in the database is locked during installation. When installing Oracle, you can directly unlock the user. If you forget to unlock t

Tags: Build table Oracle Build user Change table space name1. Build table SpaceCreate tablespace table space nameDataFile ' D:\app\Administrator\oradata\orcl\ABC. DBF 'Size 100M autoextend on next 50M extent management2. Build UsersCreate user username identified by passwordDefault Tablespace table space nameTemporary tablespace temp (default tablespace name)3, g