US ER MA NAG EMENT A ND DA TABA SE S ECUR ITY in Font

Drawer Code 39 in Font US ER MA NAG EMENT A ND DA TABA SE S ECUR ITY

CHAPTER 12 US ER MA NAG EMENT A ND DA TABA SE S ECUR ITY
Create Code39 In None
Using Barcode creation for Font Control to generate, create Code39 image in Font applications.
www.OnBarcode.com
Encode Barcode In None
Using Barcode generator for Font Control to generate, create Barcode image in Font applications.
www.OnBarcode.com
Managing Users
Barcode Creation In None
Using Barcode generator for Font Control to generate, create Barcode image in Font applications.
www.OnBarcode.com
Draw Code128 In None
Using Barcode encoder for Font Control to generate, create Code128 image in Font applications.
www.OnBarcode.com
User management is a pretty complex topic because not only does it deal with authorizing users to use the database, but it also touches on vital topics such as security and resource management. The DBA creates the users in the database and sets limits on their access to the various components. The DBA also limits the physical space and system resources that the users can use, generally by assigning database roles and setting privileges. You ll see later on how to make sure that the default passwords associated with various database users are changed soon after creating a new database. When you create a new database, the only users at first will be the application or schema owners. Later on, you ll create the actual end users who will be using the database on a day-to-day basis. For the first set of users, the application owners, you will be more concerned with allocating sufficient space and other privileges to create objects in the database. For the end users, your primary concern will be their access rights to various objects and the limits on their use of resources while accessing the database.
Painting Data Matrix ECC200 In None
Using Barcode creator for Font Control to generate, create Data Matrix image in Font applications.
www.OnBarcode.com
Code 39 Generator In None
Using Barcode encoder for Font Control to generate, create Code 39 Full ASCII image in Font applications.
www.OnBarcode.com
Temporary and Default Tablespaces
Create Denso QR Bar Code In None
Using Barcode generation for Font Control to generate, create QR Code JIS X 0510 image in Font applications.
www.OnBarcode.com
Draw USPS OneCode Solution Barcode In None
Using Barcode creator for Font Control to generate, create USPS OneCode Solution Barcode image in Font applications.
www.OnBarcode.com
All users need a temporary tablespace where they can perform work such as sorting data during SQL execution. Users also need to have a default tablespace, where their objects will be created if they don t explicitly assign a different tablespace during object creation. You can create a default temporary tablespace and a default permanent tablespace for all users during the database-creation process ( 10 explains how to create these two tablespaces). Once you have created these two tablespaces, you don t have to specify them again when you create a new database user.
Code 3/9 Encoder In Visual Basic .NET
Using Barcode generator for .NET Control to generate, create Code-39 image in Visual Studio .NET applications.
www.OnBarcode.com
Code 3/9 Recognizer In Java
Using Barcode scanner for Java Control to read, scan read, scan image in Java applications.
www.OnBarcode.com
Caution
Drawing QR Code JIS X 0510 In None
Using Barcode creator for Office Excel Control to generate, create QR image in Office Excel applications.
www.OnBarcode.com
Making PDF417 In None
Using Barcode generation for Software Control to generate, create PDF417 image in Software applications.
www.OnBarcode.com
If you don t assign a specific tablespace as the default tablespace, the System tablespace becomes your default tablespace. If a user creates a very large object in the System tablespace, he or she might take up all the space in it and make it impossible for the SYS super user to create any new objects in it, causing the database to come to a grinding halt. This is the main reason why you should always create a default tablespace for every user.
Barcode Encoder In Java
Using Barcode generation for BIRT Control to generate, create Barcode image in Eclipse BIRT applications.
www.OnBarcode.com
Data Matrix Generator In Java
Using Barcode creation for Java Control to generate, create Data Matrix 2d barcode image in Java applications.
www.OnBarcode.com
Creating a New User
Making Barcode In None
Using Barcode encoder for Word Control to generate, create Barcode image in Microsoft Word applications.
www.OnBarcode.com
Code-39 Creator In None
Using Barcode encoder for Microsoft Excel Control to generate, create Code 3 of 9 image in Excel applications.
www.OnBarcode.com
You use the CREATE USER statement to create a user. It s good practice to assign each new user both a default temporary and a default permanent tablespace. Since I m assuming that you ve already created both of these tablespaces when you created the database, the CREATE USER statement can be very simple, as shown here: SQL> CREATE USER salapati IDENTIFIED BY sammyy1; User created. SQL> This statement creates a new user, salapati, with sammyy1 as the password. You don t have to assign a default temporary or permanent tablespace to the user (assuming that you created a default temporary and permanent tablespace for the database while creating your database). You can use the ALTER TABLESPACE DEFAULT TEMPORARY TABLESPACE statement to set up a default temporary tablespace after creating a database. Query the DATABASE_PROPERTIES view to see the current values for the default tablespace. The following query shows the new user s default (permanent) and temporary tablespaces:
Creating QR Code 2d Barcode In Java
Using Barcode printer for Java Control to generate, create QR Code image in Java applications.
www.OnBarcode.com
USS-128 Printer In Visual Studio .NET
Using Barcode encoder for .NET framework Control to generate, create UCC.EAN - 128 image in .NET framework applications.
www.OnBarcode.com
CHAPT ER 12 USE R MA NAGEM ENT AN D DA TA BAS E S ECURITY
EAN-13 Recognizer In .NET Framework
Using Barcode recognizer for VS .NET Control to read, scan read, scan image in Visual Studio .NET applications.
www.OnBarcode.com
Universal Product Code Version A Printer In Java
Using Barcode creator for BIRT Control to generate, create UPC-A Supplement 2 image in BIRT reports applications.
www.OnBarcode.com
SQL> SELECT default_tablespace, temporary_tablespace 2 FROM dba_users 3* WHERE username='SALAPATI'; DEFAULT_TABLESPACE ------------------USERS SQL> The new user can t connect to the database, however, because the user doesn t have any privileges to do so. This is what happens when the user salapati tries to connect using SQL*Plus: $ sqlplus salapati/sammyy1 SQL*Plus: Release 11.1.0.6.0 - Production on Fri Mar 21 11:55:38 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved.ERROR: Ora-01045: user SALAPATI lacks CREATE SESSION privilege; logon denied Enter user-name: In order for the salapati user to connect and start communicating with the database, you must grant the CREATE SESSION system privilege to the new user, as shown here: SQL> GRANT CREATE SESSION TO salapati; Grant succeeded. SQL> If you ve followed the Oracle-recommended practice and have created default temporary and permanent tablespaces when creating the database, any new user you create will be able to use them instead of using the System tablespace as the temporary and default tablespace by default. In any case, after you create a user, the new user can t create new objects, such as tables and indexes, right away. In the following example, USERS is the default permanent tablespace for the database, and you can see what happens when the user tries to create a table: SQL> CONNECT salapati/sammyy1 Connected. SQL> CREATE TABLE xyz (name VARCHAR2(30)); create table xyz (name varchar2(30)) * ERROR at line 1: ORA-01950: no privileges on tablespace 'USERS' SQL> Let s say you assigned the default permanent tablespace USERS to all users. Since user salapati didn t specify a tablespace for creating the new xyz table, Oracle tries to create it in the default permanent tablespace, USERS. However, the user wasn t granted any quota on the tablespace. By default, users aren t given any space quotas on any tablespaces. Since the user is assigned the USERS tablespace but isn t allocated a quota of space in that tablespace, the user can t create any objects in the USERS tablespace. You must explicitly allocate tablespace quotas to a user. It s common to assign specific tablespace quotas at user creation time. Here s how you grant a space quota on a tablespace to a user: SQL> ALTER USER salapati 2 QUOTA 100M ON users; User altered. SQL> TEMPORARY_TABLESPACE ------------------------TEMPTBS_01
Copyright © OnBarcode.com . All rights reserved.