Security :: SQLs To Monitor User Access?
Jul 2, 2011There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?
View 9 Replies
ADVERTISEMENT
Security :: Restricting User Access?
Oct 17, 2010The application user owns the application schema which owns all the database objects in this schema. Now 50 of our developers need access to this application schema but giving away the password for the application user is risk as "Drop user application cascade" and wipe off all the objects. The option i have is to create 50 separate users with tablespace as application and grant all rights to application schema.
View 9 Replies View RelatedSecurity :: Find Out The User Access The Database?
Nov 8, 2011Is there a way to find out the user access the database?
View 1 Replies View RelatedSecurity :: Create User With Full Access On Default Tablespace?
Aug 12, 2011i have been trying to create a user with full access on default Tablespace so that i can access all the objects without any restrictions for the new user.
View 7 Replies View RelatedSecurity :: Provide Read / Write Access To Oracle User?
Jun 2, 2011I will have to provide read/write access to an oracle user. What privileges should i grant to the user so as to enable the user to read from and write to the files?
View 2 Replies View RelatedHow To Monitor Drop User
Jan 31, 2013How to monitor the DROP USER command?
OS: AIX, Oracle: 11.2.0.2
Forms :: Login User From One CANVAS And Access Second As Per-user Rights?
Oct 20, 2012- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?
- i have created a login form in one canvas.
- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query
SELECT COUNT (*)
INTO v_count
FROM usersinfo
WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;
[code]...
Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .
Real Application Clusters :: Monitor Incident Or Regular Health Checkup Under Grid And Oracle User?
Apr 15, 2013I am new in RAC scenario though i have some system to look after. I want to know, like single instance there is alert log,trace log where we should investigate to check if there is any problem. For RAC system which are the logs that i can find the monitor the incident or regular health checkup under grid and oracle user?
View 3 Replies View RelatedSecurity :: Tracking User Security Violations
Jul 27, 2010Provide me the script which would track all the users security violations like ... say for example i want to find which users logged in and what he did in database prospective.
View 1 Replies View RelatedSecurity :: Authenticating Oracle User Based On Windows User ID?
Mar 11, 2011We are trying to implement the following security to our database.
As of now, the access rights are same for all the windows users logging into the Oracle application with the same Oracle user Id.
But now, we want to improve our security by granting different levels of rights to the users based on their Network Id even though they use the same Oracle User Id to log into the application.
We are not looking for the users to be identified externally.
(CREATE USER "OPS$ORACLE-BASE.COMTIM_HALL" IDENTIFIED EXTERNALLY;
GRANT CONNECT TO "OPS$ORACLE-BASE.COMTIM_HALL";
)
Security :: User Locked / Track User Who Hit Wrong Password
Dec 21, 2010We have the database user called c88888 and is locked yesterday. I came to this with the following query.
select * from dba_users where username like 'C88888';
Due to invalid password the user was locked. Can we track who hit the database with the wrong password?
Security :: User Should Be Able To Read All The Objects Of User?
Sep 12, 2011User A contains tables, views, LOB's, types, procedures, triggers, sequences, indexes, synonyms. User B wants to have read-only privilege on the objects of User A.
I can provide select on privilege on tables and views. How about providing read-only privileges to other objects?
Security :: To See Any Database For The Operations Of Sys User Or Any Other User
Aug 23, 2011I have enabled Auditing in my oracle Database but I am not able to see any database for the operations of sys user or any other user in my "SYS.AUD$" and "SYS.FGA_LOG$" tables.
Value for the parameter "AUDIT_TRAIL" is set to "db,extended".
I am working as "SYS" user and I have shutdown and again startup the database but neither there was any information in both the tables nor I can see any files at the destination specified by "AUDIT_FILE_DEST".
SQL & PL/SQL :: DBA User Access To Other User Objects
Dec 6, 2010when a dba user'AA' try to access other user'BB' object it gives error pls-00201 identifier 'BB.function_name' must be declared. However the procedure of BB user are being accessible.
View 17 Replies View RelatedSecurity :: Resource Access Descriptor And SSO
Sep 22, 2010I am trying to get to where I can add a RAD (Resource Access Descriptor) to allow connection to an oracle database. Right now I have "No Configuration Privilege" when logging onto Oracle Identity Management.
How to I get to the configuration tab? What privilege do I need?
Tuning SQLs In A Batch Process
Mar 18, 2013I'm having an issue with stale optimizer statistics for some SQLs that are run in a batch process. The problem is that the process runs many times during the day - sometimes 20 to 30 times. And each time, the tables are updated, i.e. rows are inserted or deleted, etc.
So eventually the optimizer statistics for those tables become stale and the performance of the SQLs start to slow down (a lot). How best to gather the optimizer stats on the tables so they don't become stale when the batch process runs each time? The problem is that I also can't add/modify the code in the batch process because it is delivered by the vendor as is.
Security :: Ensuring Read Only Access To Any Table
Jul 27, 2012I am an auditor. I need to ensure that a perticular user at any cost should not be able to update contents of a table.
Privileges granted:
GRANT SELECT ANY TABLE TO "ABC"
GRANT ALTER SESSION TO "ABC"
GRANT CREATE SESSION TO "ABC"
Can abc modify, alter contents of a table?
Security :: How To Get The Data Access For A Temp Table
Jul 9, 2013How to get the data access for a temp table ?
View 5 Replies View RelatedSecurity :: Restricting DBA Access To All Data Of The Tables (Encryption / Others)
Nov 4, 2012We have got a new requirement wherein, The customer wanted the DBA Vendor (US) NOT to access the confidential information (ALL Columns) in the DB tables of PRODUCTION database. This is for few applications to comply with with export control rules. The thin support by Customer DBA will be allowed to access the Data, if required .
1) Web Based Interface ?.
2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)
3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)
4) Standard Tools / Utilities / Others ??.
Technologies are Oracle ,SQL
Security :: How To Restrict Access To Table (Database Vault)
Nov 12, 2012I configured a simple security configuration for the HR sample database schema. URL....
Now system user can't select data from table hr.employee, but HR user still can. How to restrict access to table for table owner?
How To Access Tables Of Another User
Sep 26, 2013how to acess tables of another user from the sys user as dba in oracle 8 dont have the password but need to acess the table
View 1 Replies View RelatedForms :: Restrict User To Access Records
Mar 26, 2012 I am using Forms 6i,Oracle Apps... I have database block.... generally we can retrieve the all the records by press F11 and Ctrl F11.... but my requirement is i have to restrict the user that they can access the records based on the condition ...
For example....let we take emp table....I have to restrict the user that they can query dept no 10 employees only.
Server Administration :: DB Link For One To Many User Access
Sep 14, 2010I need to create one to many user DB link in oracle 10g. Meaning I have a user A in database 1 and I want to access the objects from user B,C,D in database 2, how to create a public database link so that i can have this one to many user access?
View 8 Replies View RelatedAccess Oracle Database From Root User?
Dec 18, 2012i have an linux instance running oracle 11g as oracle OS user. i am able to connect the DB from clients.
i need to access this DB from OS root user. what should i do.
Server Administration :: DB Link Access To User
Sep 3, 2013I have login through the sysdba and created dblink and modified the tnsnames.ora for necessary changes. And the it started working correctly and I can able to get the data by selecting it.But when I login with different user that is showing the following error.
ORA-12154: TNS:could not resolve the connect identifier specified
How to resolve this,is there any privileges or permission need to give to that user.
Application Express :: How To Access User Information
Jan 2, 2013 I am new to Oracle APEX, and have a few questions regarding the user information.
I've created a new workspace on my local APEX installation, created some users in the workspace, and divided them into roles as "Managers" and "Employees". I am the only Dev and Admin of the workspace, and the users (Managers and Employees) I have created are viewers.
I'd like to create database tables in the workspace where some field would refer to the user ID of the created user as a foreign key, and their role. Similarly, I'd like to create pages where a particular region is displayed only if the logged in user is a "Manager". How can I access the user data and the role data using SQL?
I see following tables in my workspace, so which table contains the user information:
APEX$_ACL
APEX$_WS_FILES
APEX$_WS_HISTORY
APEX$_WS_LINKS
APEX$_WS_NOTES
[Code]....
Grant User Access To Role With Limited Exposure?
Oct 23, 2012I have a role in my Oracle 10g instance like below:
GRANT ALTER USER TO <role_name> WITH ADMIN OPTION;
And this works fine for any user who has:
GRANT <role_name> TO <user>;
What I need is to limit <user> to only have the ALTER USER privilege to a set of users. Preferrably where the set of users are identified by a column value in a table, something like:
WHERE PeopleTable.InList = "YES"
Or maybe where set of users are defined by their membership in another role.
GRANT ALTER USER TO <role_name> FOR USERS IN MEMBERS_LIST_ROLE;
SQL & PL/SQL :: Create Trigger That Will Fire Whenever Any User Will Access Schema Of Oracle
Oct 31, 2011I would like to create a trigger that will fire whenever any user will access to a Schema of Oracle DB (for each and every login). regardless the access will be through an application or SQLPLUS and this trigger must insert the below information into a table.
1) IP address
2) Machine Name
3) login time
4) logout time
5) name of accessed schema
writing this trigger and creating the table that will hold the required data.
SQL & PL/SQL :: Column Access In Table Based On User Parameter Input
Nov 10, 2010Need to access data in a table base on user parameter input where the data is stored like a spreadsheet with column headings JAN, FEB, MAR... and the rows are the years. Is there a way to create a generic SQL statement so that I don't have to have 12 if statements in the procedure?
View 5 Replies View RelatedEnterprise Manager :: Export Dashboards Or Access Them Via Anonymous User?
Jan 28, 2013We have OEM and within are some great metrics and dashboards, with key information.We want to post some of these dashboards and metrics on our wiki page and/or within our application dashboards (we use jaspersoft.com/)
We do not want to give our normal users the access into OEM, so is there a way to somehow export these dashboards or access them via an anonymous user somehow?Either the dashboards themselves would be great, or somewhere to export the data the dashboards user - as i can then create the dashboards myself using the data.
example of dashboards/info to use would be:
- General, Host CPU, Active Sessions, SQL Response Time, Space Summary, etc...
