17 January 2012

Step by Step Create read only user in oracle

Step to Create Read only User in Oracle

create role muthu_role;   --- Give new Role name

Oracle Auditing is configured to use the Database Audit Trail, type the following command:

grant select on DBA_AUDIT_TRAIL to muthu_role;

create user muthu identified by password;   --   Create  User

Oracle Auditing is configured to use the XML Audit Trail, type the following command:

grant select on V_$XML_AUDIT_TRAIL to muthu;

grant connect to muthu;

grant muthu_role to muthu;

SQL> spool table.sql
SQL> SELECT 'GRANT SELECT ON APPS.' ||TABLE_NAME || ' TO MUTHU_ROLE;' FROM DBA_TABLES --WHERE OWNER='APPS';

GRANT SELECT ON APPS.HYA_PERSONAL_VAR TO MUTHU_ROLE;
GRANT SELECT ON APPS.HFM_ERRORLOG TO MUTHU_ROLE;
GRANT SELECT ON APPS.HSX_DATASOURCES TO MUTHU_ROLE;

'GRANTSELECTONAPPS.'||TABLE_NAME||'TO MUTHU_ROLE;'
----------------------------------------------------------------------
GRANT SELECT ON APPS.HSV_ACTIVITY_USERS TO MUTHU_ROLE;
GRANT SELECT ON APPS.HSV_ACTIVITY_SESSIONS TO MUTHU_ROLE;
GRANT SELECT ON APPS.HSV_USERS_ON_SYSTEM TO MUTHU_ROLE;
GRANT SELECT ON APPS.HSV_ACTIVITY_KILL_USERS TO MUTHU_ROLE;
GRANT SELECT ON APPS.HSV_ACTIVITY_NO_ACCESS TO MUTHU_ROLE;

8145 rows selected.

SQL> SELECT 'GRANT SELECT ON APPS.' ||VIEW_NAME || ' TO MUTHU_ROLE;' FROM DBA_VIEWS WHERE OWNER='APPS';

no rows selected

SQL> spool off
SQL>@table.sql


Creating Trigger:-

create or replace trigger log_on_after_MUTHU
after logon ON MUTHU.SCHEMA
BEGIN
EXECUTE IMMEDIATE 'alter session set CURRENT_SCHEMA = APPS';
END;
/


16 January 2012

Step by Step Oracle EPM System 11.1.2.0.0 Installation on Windows 7 64bit part -4

Oracle Enterprise Performance Management System (EPM System) 11.1.2.0.0 Installation on Windows 7 64bit part -4

Click Next


Click Next

 Click Next


 Click Next


Click Next


Click Next






Click Next


Click Next


Click Next


Click Next


Click Next


Click Next


Click Next


Click Next


Click Next


Click Next






Click Start => All Programes  => Oracle EPM System=>Essbase=>Essbase Administration Services=> Start Administration Services Console
Administrator server    -  Muthu
Username   =>  admin
Password    =>  password


Right Click Essbase Server click add Essbase Server





Url  :   http://muthu-pc:19000/workspace/index.jsp   or  http://localhost:19000/workspace/index.jsp
 Username = admin
Password = password




Step by Step Oracle EPM System 11.1.2.0.0 Installation on Windows 7 64bit part -3

Oracle Enterprise Performance Management System (EPM System) 11.1.2.0.0 Installation on Windows 7 64bit part -3

Select Deploy to application server
Click Next


Select Deploy Web application to a New domain
I used below details 
Domain name =  EPMSystem
Administrator server Port = 7001
Administrator User = epmadmin
Administrator Password  = weblogic1
Click Next


Click Next


Click Next



Click Task Panel


Provide all Database details

Click Next


Select Deploy to Application  Server
Provide all details
Administration Server Host  = Muthu-PC
Domain name =  EPMSystem
Administrator server Port = 7001
Administrator User = epmadmin
Administrator Password  = weblogic1
Click Next



Click Next


Click Next


Click Next


Click Next


Click Next



Click task panel


URL  :  http://muthu-pc:28080/interop/index.jsp    or   http://localhost:28080/interop/index.jsp
Username   =  admin
Password  = password




Oracle EPM System 11.1.2.0.0 Installation on Windows 7 64bit part -4  Click here


Step by Step Oracle EPM System 11.1.2.0.0 Installation on Windows 7 64bit part -2

 Oracle Enterprise Performance Management System (EPM System) 11.1.2.0.0 Installation on Windows 7 64bit part -2
Before start the configuration Install Oracle Database Installation steps  Click here


Create EPM Oracle Instance

Select Create new EPM Oracle Instance
Home directory = D:\Oracle\Middleware\user_projects
EPM Instance name =  epmsystem1
Click Next


Select Perform First-time Configuration of Shared Service database
Provide all database detail 
then  Click Next


Select Hyperion Foundation Click Next


Provide all mail server Details  Click Next


Click Next


Provide Shered Service admin password .I used password  Click Next


Click Next



Click Task panel


Oracle EPM System 11.1.2.0.0 Installation on Windows 7 64bit Part -3 Click here