>
> Mr. Ari Kaplan,
>
> Remember me. Some time back I contacted U regarding Rollback Segments,
> Now I want some details regarding Schemas.
>
> 1. Upto my knowledge Schema is created by default with the same name
> as the username. But can I create Schemas on my own and assign
> some users to use that Schema ?
>
> Please give me some real life examples of Schemas.
A schema is a user account, along with all of the objects owned by that
user account. So, one thing you can do is create tables under one user account
and grant SELECT, INSERT, UPDATE, and/or DELETE privileges to PUBLIC or roles
or other user accounts. Also you can do the same for synonyms (CREATE PUBLIC
SYNONYM x for username.x).
>
> 2. Let us say I have the following table :
>
> table name : LOG_FOR_USER_SESSIONS
> owner : SYS
>
> column name datatype description
> --------------------------------------------------------------
> USER_NAME VARCHAR2(30) STORES USERNAME
> DIS_CONNECT_TIME DATE STORES CONNECT TIME OR
> DISCONNECT TIME
> CONNECT_OR_DISCONNECT VARCHAR2(1) STORES 'C' IF CONNECT
> STORES 'D' IF DISCONNECT
> ----------------------------------------------------------------
>
> Now tell me how do I store information regarding user connects and
> disconnects into the about table.
Don't mess with SYS tables. What you should do is set up database auditing.
You can audit to this LOG_FOR_USER_SESSIONS table or to a file. Look at your
Oracle documentation on Auditing.
>
> 3. Is there any way to update DYNAMIC PERFORMANCE TABLES.
No. They are read-only VIEWS (they are not tables).
>
> THATS ALL FOR NOW
>
> THANX IN ADVANCE FOR HELPING ...
>
Best of luck,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page