Discover grant privileges to user in oracle 11g, include the articles, news, trends, analysis and practical advice about grant privileges to user in oracle 11g on alibabacloud.com
and datafiles;Modify table space Size (Note: Modify = can be increased and can be reduced.) )alter?database?datafile '/u01/app/oracle/oradata/orcl/ittbank.dbf ' resize 200m;Increase table space Size (Note: increase = can only increase, cannot be reduced.) )alter tablespace ittbank add datafile '/u01/app/oracle/oradata/orcl/ittbank.dbf ' size 2048m;Querying database files:select * from Dba_data_files;To que
PS: The following are the most common basic management commands for Oracle 11g, including creating users, table spaces, permission assignments, and so on. The following commands I have verified the operation, and added my summary and instructions.1. Start the Oracle database:Switch from root to Oracle
internally. Regardless of which method you choose, you need to create one or more users within the database that allow operational data.User and Schema (schema)To create the user's syntax:Create user username identified by password default Tablespace table space quota size on table space;Note: While user names are written in lowercase when they are created, they are capitalized when stored in a data dictio
created in lowercase Tom, it is capitalized in the data dictionary, so you also need to write uppercase when queryingDelete Tom UserDrop user Tom;Create user "Tom" identified by Oracle;Delete Tom UserThe correct way to delete this should be:Drop user "Tom";Create user tom,
1. automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (The table contains the default user name and password ), the user name and password are all invalid. Finally, you have tried dbsnmp/dbsnm
Instance code for Oracle 11g User Password modification and lock/unlock function, oracle11g
1. Run cmd.exe;
2. Enter sqlplus/as sysdba to connect to the database as a system administrator (sysdba) for database management.
3. After successful connection, run
Alter user identityName identified by password; -- Change pass
This article introduces some common statements used to import and export tablespaces in oracle 11g linux. For more information, see.
Sqlplus
/As sysdba
-- View the dbf storage locationSelect * from dba_data_files; -- view the file location SELECT * FROM dba_directories;-- Create a tablespaceCreate tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf' size 100 m autoextend on next 50 m max
2014Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:Ora-01017:invalid Username/password; Logon deniedPlease enter user name:C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 17:52:35 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connect to:Oracle Database
Tags: Ops directory sed nal RTM user its source users Oracle HR Example User's build 10g,11g can be Put the 10. sql files on the attachment (see the end of the article) in this path first: $ORACLE _home/demo/schema/human_resources
Script Name
Description
Hr_analz.sql
objects even if they is Lockedobj_filter_lista List of object fil Ters. When provided, Gather_schema_stats would GATHER statistics only on objects which satisfy at least one object filter in the List as needed. In a single object filter, we can specify the constraints on the object attributes. The attribute values specified In the object filter is case-insensitive unless double-quoted. Wildcard is allowed in the attribute values. Suppose non-null values S1, s2, ... is specified for attributes A
1,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 Administrator role) system : DBA(
Label:When you install Oracle, the default password is as follows if you do not reset the password for the following users: Username/Password Login ID descriptionSys/change_on_install SYSDBA or Sysoper cannot log on as NORMAL and can be used as the default system administratorSystem/manager SYSDBA or NORMAL cannot log on as Sysoper and can be used as the default system administratorSysman/oem_temp Sysman user
Label:Oracle 11g before the default user is not the limit of password expiration, in Oracle 11g, the default profile enabled password expiration time is 180 days. As follows:SELECT * from Dba_profiles where profile= ' DEFAULT ' and resource_name= ' password_life_time ';Expired passwords can be modified by the alter
The Oracle HR sample user's build 10g,11g can bePut the 10. sql files on the attachment (see the end of the article) in this path first:$ORACLE _home/demo/schema/human_resources
Script Name
Description
Hr_analz.sql
Collects statistics on the tables in the schema.
Hr_code.sql
Creates procedural objec
) Statistics need to authorize the statement Grant create session,connect to DW; GrantSelectOn V_$sql to DW; GrantSelectOn v_$session to DW; GrantSelect, insert on Timdba.uc_logon_off to DW; --(2 Create a temporary table that records all user create table TIMDBA. Z_users as SelectDistinct owner fromall_objects; --(3 generates an authoritative SQL statement Select 'Gran
A.granted_role=b.granteeUnionSelect Grantee,privilege,owner,table_name from Dba_tab_privs) dwhere exists ((select 1 from dba_users C where d.username=c.username))Order by;4. How do I see who has a DBA role? general practice is to directly query the Dba_role_privs view. The query statements are as follows:Select Grantee,granted_role from Dba_role_privs where granted_role= ' DBA '; //This will miss the userthe correct query should be queried by the following statement:SELECT * FROM (SELECT DISTIN
When you install Oracle, if you do not reset the password for the following users, the default password is as follows:
User name/Password login Identity descriptionSys/change_on_install SYSDBA or Sysoper cannot be logged in as NORMAL as the default system administratorSystem/manager SYSDBA or NORMAL cannot be logged on as a sysoper, as the default system administratorSysman/oem_temp Sysman as OMS
1. Start Sqlplus2. Please enter your username: Sqlplus/as sysdba3. Enter Password: direct return(Note: For SYS both lock and not lock can be locally certified log into SYSDBA)4. Connect to:Oracle Database 11g Enterprise Edition release 11.2.0.1.0-productionWith the partitioning, OLAP, Data Mining and real application testing optionsSql>alter User sys identified by admin;The
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.