Shulou(Shulou.com)06/01 Report--

How to create the best and safest online user for Oracle!

Knowledge points to consider

1.undo tablespace settings

two。 Business tablespace settings

3. Temporary tablespace settings

4. Tablespace quota

The choice of 5.profile, self-built or default

6. Password security

7. Permission restriction

.

Description:

Because it is a demonstration environment, the tablespace size is for demonstration purposes only and is not representative. You can set up these knowledge points together according to your own actual situation.

1.undo tablespace resize, here is the test environment is just a demonstration, the production environment usually initializes 16GSYS@orcl1 > select file_name,tablespace_name from dba_data_files where tablespace_name like 'UNDO%' FILE_NAME TABLESPACE_NAME----+ DATADG/ORCL/DATAFILE/undotbs2.265.954539975 UNDOTBS2+DATADG/ORCL/DATAFILE/undotbs1.260.954539485 UNDOTBS1SYS@orcl1 > alter database datafile'+ DATADG/ORCL/DATAFILE/undotbs2.265.954539975' resize 200m Database altered.SYS@orcl1 > alter database datafile'+ DATADG/ORCL/DATAFILE/undotbs1.260.954539485' resize 200m database altered.2. To create a business tablespace (the default is non-automatic extension, the maximum is 200m), it is recommended to set a fixed size, and then add a data file. SYS@orcl1 > create tablespace roidba datafile'+ datadg' size 200m Tablespace created.-- add a data file alter tablespace roidba add datafile'+ datadg' size 200m Tablespace 3. Create a temporary tablespace SYS@orcl1 > create temporary tablespace temp_roidba tempfile'+ datadg' size 200m Tablespace created.-- to add a temporary file SYS@orcl1 > alter tablespace temp_roidba add tempfile'+ datadg' size 200m politics Tablespace altered.4. Create the user CREATE USER roidba IDENTIFIED BY roidba DEFAULT TABLESPACE roidba QUOTA unlimited ON roidba TEMPORARY TABLESPACE temp_roidba PROFILE default ACCOUNT UNLOCK;5. Authorization-remember not to grant DBA permissions, which do not meet the requirements checked above SYS@orcl1 > grant connect, resource to roidba;Grant succeeded.6. Password security policy (which needs to be configured according to customer requirements)-at least modify this item SYS@orcl1 > alter profile default limit PASSWORD_LIFE_TIME unlimited;Profile altered. The above are the knowledge points that we need to consider when creating users. I just list the knowledge points, including the size of the tablespace, password complexity, and permission design according to the specific situation. in general, financial customers will have their own requirements for creating users, as long as they are created in accordance with the specifications.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.