How To Restrict Clients Access

Jan 9, 2013

I am having one requirement that i have to restrict the access of oracle database from clients.

suppose i am having 10 users and they have all information related login like username, password, database servers details etc but then also they should not get login into my database, i have to restrict some of them like i have to provide access to 5 users only out of that 10 users.

View 3 Replies


ADVERTISEMENT

Forms :: 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.

View 11 Replies View Related

Security :: How To Restrict Access To Table (Database Vault)

Nov 12, 2012

I 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?

View 1 Replies View Related

SQL & PL/SQL :: Query To Get Overall Status For Clients

Sep 11, 2010

I have a clients table called CLIENTS. One of the fields in this table is called 'status'

I need to set this status field, depending on if the transactions for this client have passed.

The transactions are in a table called TXNS and has fields
client_id, txn_id, txn_status

txn_status can be 'success' or 'failed'

I need to somehow set the overall 'status' field on CLIENTS to success or fail depending on if any transactions failed or not

So for every client I want to list the status, any query that can possible list the overall status for the client?

select client_id, MAX(status)
from txns
group by client_id

but the max(status) bit needs to get the overall status part

View 10 Replies View Related

(TNSNAMES) Shared For All Oracle Clients?

Jun 19, 2012

Way to share or manage the TNSNAMES.ORA file for all oracle clients in same place?I already have a TNSNAMES.ORA configured and running in the machines (locally).The problem is that any change done( ip, port etc), imply in update all files in all the Oracle clients

View 1 Replies View Related

SQL & PL/SQL :: How To Get Distinct List Of Clients From 2 Tables

Nov 8, 2010

I have 2 tables which contain 1000's of cash and stock transactions and I need to somehow get a list of the distinct clients

select distinct client_id
from pf_cash_txns pct, pf_stock_txns pst

Quote:ORA-00918: column ambiguously defined

View 5 Replies View Related

Oracle Clients Immediately Logging Off?

Nov 4, 2011

I got a call today saying that some users were having a hard time logging on to Oracle using our in-house PowerBuilder-built application. I have Oracle 10.2.0 running on 32-bit Windows 2003. Poked around a little, looking in the dump directories, checking CPU utilization, checking OEM to see if there were any obvious performance issues or blocking issues or whatever - didn't see anything unusual. Logged in with SQL Plus with no problem. Then I checked the audit logs. All we audit is user logons and logoffs. What I was seeing is that a handful of users were showing a logon event with a logoff (action 101) 10 to 15 seconds later. One user in particular was showing this over and over again.

View 1 Replies View Related

Server Administration :: Clients Can't Connect To Database - ORA-12560

Nov 28, 2011

Since 13.00 hours, my clients can't connect to the database, and hence cannot access their application.

They get a ORA-12560 error. protocol adapter.

What I have discovered and done so far.

1. I can tnsping dbname -> OK.

2. I have rebooted both application server and databaseserver multiple times

3. I haven't touched tnsnames.ora, sqlnet.ora and listener.ora and they look to be in perfect mint condition.

4. I have full access to access the database instance via web.

5. I can connect to the database instance via sql

6. I have restarted the oracle-services: oracleDBConsoledbname, OracleOraDb20g_home1TNSListener and OracleServicedbname

7. I have rebooted the client computers, and the file server.

8. I don't see any errors in event logs, both on file server, client computer and database-server.

9. When I press down the link Listener, I get Metric Collection Error, which means I might not access it?

10. The only alert I find is that filesystem D: only has 15.62% available space.

They have been using the database for a very long time without any trouble, and suddenly boom.What do I do? How do I check things?

View 22 Replies View Related

Networking And Gateways :: Logs Or Queries To Monitor Clients IP

Oct 13, 2012

Is there any logs or query where I can monitor client's IP previously connected to the database? I have created 2 listener with 10.1.2.x and 10.1.100.x network. I would like to separate the oracle traffic to the 10.1.100.x alone. As of now both can connect to the database. I like to monitor if everybody is already transferred to the 10.1.100.x network before I will disable the 10.1.2.x.

View 2 Replies View Related

Windows :: Oracle Client Need To Install Its Clients Over Several Desktops

Apr 1, 2011

I have an Oracle server with Oracle 11g R2 and need to install its clients over several desktops.I am using 2 separate installs, but I think that this might be redundant.The 2 setups I'm using are:

- ODAC 11.2 Release 3 and Oracle Developer Tools for Visual Studio (11.2.0.2.1)
- 64-bit Oracle Data Access Components (ODAC) Downloads

- Is really necessary to install both of the 2 setup, or there is something I can use once instead of it?

View 4 Replies View Related

Networking And Gateways :: Clients Connections Failed Intermittently?

Jul 16, 2012

have some problem between my database and the listener Sometimes I have connection errors: The error occurred intermittently

Oracle 11.2.0.2.0 on RHEL 5
My listener:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
LISTENER =

[code]...

The listener starts and stops normally
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
>lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 17:51:09
Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /opt/oracle/product/EE_11.2.0/bin/tnslsnr: .

[code]...

But there is an error when the database register into the listener (in listener.log):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Started with pid=4029
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Listener completed notification to CRS on start

[code]....

View 2 Replies View Related

Forms :: Conversion - Make It Accessible Based On Browser To Clients?

Jul 6, 2011

i have developed an oracle form application in oracle developer 10g, now i want to make it accessible based on a browser to the clients(make it a web aaplication form)

View 3 Replies View Related

Application Express :: ORA-24247 / Network Access Denied By Access Control List

Apr 5, 2013

When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.

I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.

ORA-24247: network access denied by access control list

<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI

<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?

DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;

[code]...

View 4 Replies View Related

ORA-24247 / Network Access Denied By Access Control List (ACL)

Dec 12, 2012

I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18

is it possible to send mails from oracle database in STANDARD Edition?

View 1 Replies View Related

SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)

Nov 15, 2011

While Running the proc,it's raising the below error.

Error report:

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33
ORA-06512: at line 1

[code]....

View 12 Replies View Related

Restrict User In PL/SQL

Apr 30, 2011

Suppose there is customers table and the user (Scott) is having select,update,insert privelege on the customers table.

a.)From the form i.e GUI he is having all the access,we want that when he logs on with sql plus directly then he would only be able to run select query only.

b.)When we are using third party tools such as pl/sql developer tools and toad then we are not able to restrict the user by running only the select queries.The utility which was used previously was only used for SQL Plus.

Resolution:

a.)I am able to restrict the user when he logs on with sqlplus and he is able to run anly select queries.
b.)How we can restrict the user so that in pl/sql he is able to issue only the select query.

Trigger the user when logs on session id is captured and user can be restricted in logging in to the plsql developer and toad applications

View 3 Replies View Related

Security :: Restrict DML On Table?

Jul 26, 2011

I have a table which contains secret data, i want that nobody can query,insert,update or delete that table, we can do by creating a table and giving rights to specific person but problem is that our programmers can query that table while working on that database.

Is there any other event or trigger which check that if person is performing DML on secret table then an error may generate.

View 10 Replies View Related

How To Restrict Sqlplus As Sysdba

Apr 29, 2013

how to restrict sqlplus as sysdba

C:> Set Oracle_sid=Mydb
C:>sqlplus / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

I don't want to log in any one as sqlplus / as sysdba.If they can able to login as sqlplus / as sysdba then they can see others schema in the database.Say if i set

SQLNET.AUTHENTICATION_SERVICES=none

no one can log in as sysdba were as later some one changes to

SQLNET.AUTHENTICATION_SERVICES=NTS
After they changes to NTS they can log in and access other user details right ? how to restrict

Oracle version: Oracle 11 g
OS Version :Win 7

View 21 Replies View Related

PL/SQL :: How To Restrict Null Values

Jul 20, 2012

I have main query..And i written a Query for Issued Quantity. The query is retrieving exact data. And when i add the Query in main query the data is coming with extra null values.

for ex. Query for Issued Qty fetch 16 records. and i run the main query it fetch 20 records...there r 4 records which issued Qty is null. How can i restrict that records.

View 14 Replies View Related

Forms :: How To Restrict Update Of A Block

Feb 22, 2011

I want to give update rights of a block to restricted set of people... how can i achieve it???

View 3 Replies View Related

SQL & PL/SQL :: How To Restrict Data Dictionaries To A User

Jun 21, 2011

I have a user ( for example Scott) and he doesn't belongs to DBA group i want to restrict accessing data dictionaries like dba_% to this Scott user. how to restrict Data dictionaries to this user.

View 9 Replies View Related

SQL & PL/SQL :: How To Restrict Duplicate Values From Query

Sep 15, 2012

I have below query.. When i run this query i need to get two rows.. But i am getting two more duplicate rows.. I want to restrict these two rows..

How can i do this.. Here the problem is when i join B query then only i am getting duplicate rows..

SELECT DISTINCT B.TIC_ID, B.TIC_ISS_NO,
B.TIC_NUMBEC||CEV_ID,
B.TIC_NUMBEC, B.CEV_ID, B.AOSTED_DATE,
B.COMAANY_CODE, B.CONTCACTOC_NAME,
B.FC_CODE, B.C_NO, B.FC_TYAE,
[code].......

View 4 Replies View Related

SQL & PL/SQL :: How To Restrict User At Data Level

Feb 17, 2010

Is it possible that we restrict user at data level? For Example 'A' user can only query employeess of deptno 10 only. He can not query employees of others dept.

View 6 Replies View Related

Forms :: Restrict Duplicate Records

Jul 18, 2011

there is non database data block of table type.

now i want restrict user that he will not enter same number again.

View 3 Replies View Related

Query On PRAGMA-RESTRICT-REFERENCE?

Jun 2, 2009

CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG
(V_ID in PLAYER_BAT_STAT. PLAYER_ID%TYPE)
RETURN NUMBER
IS
V_AVG NUMBER;

[code]...

This function must be moved to a package. Which additional statement must be added to the function to allow you to continue using the function in the group by the clause of a select statement?

A. PRAGMA RESTRICT_REFERENCES (CALC_PLAYER_AVG, WNDS, WNPS);
B. PRAGMA RESTRICT_REFERENCES (CALC_PLAYER_AVG, WNPS);
C. PRAGMA RESTRICT_REFERENCES (CALC_PLAYER_AVG, RNPS, WNPS);
D. PRAGMA RESTRICT_REFERENCES (CALC_PLAYER_AVG, ALLOW_GROUP_BY);
Answer: A

----I had gone through this question in dumps,about PRAGMA_RESTRICT_REFERENCES, but i m not aware of WNDS, WNPS..or reference for this term, & how it works in above exampl

View 1 Replies View Related

Forms :: To Restrict Record Deletion

Nov 6, 2011

When i opened the form and after querying the records if I press CTL+ Down Arrow the record is deleted.

This is the normal runtime form behavior. When ever pressing CTL+ Down arrow I don't want to delete the record, I tried with KEY-DELREC but it is not happening.

View 3 Replies View Related

Forms :: How To Restrict Update In S Specific Field

Jul 9, 2012

I'm trying to restrict update in a specific field in my form . I have set its property(update allowed) to no and still the field is update able. I am also having on-commit trigger in my form level that well display a message and followed by the command commit. is it possible the trigger is overriding the property(update restriction).

View 9 Replies View Related

Forms :: Restrict Standard Save Functionality?

Jun 20, 2011

how can we restrict standard save button functionality in custom form?

View 4 Replies View Related

Forms :: How To Restrict User On Key Next Item Trigger

Sep 16, 2011

SQL Plus version Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 Production
Forms Version : 6i
Reports Version: 6i
O/S : Microsoft Windows Xp professional Version 2002 Service Pack 3

With reference to the above version details here is the requirement. How do I restrict user on key next item trigger i.e I want the cursor to move to next field only when user presses "ENTER" button on the key board any other key like mouse should not allow user to move to the next field.

View 23 Replies View Related

Forms :: Restrict Field After Insertion Before Commit?

Nov 9, 2010

Restrict field after insertion before commit. i mean when user inputs the data in one field and moves to next field.when ever he want to return back on the previous field it can't be edited.before commit;

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved