While trying to logging to database through pl/sql developer, getting error as "ORA-01031: insufficient privileges".But am able to logging by system.
As per the instruction by the below link, checked the privileges of ord_dba. All are correct. Now, i am in puzzle to rectify the error.
[URL]
i have three scheme in one instance for example
x,y and z
i create view in x as x_view
next step create view in y as y_view select from x_view ;
and finished, create another view in z as z_view select from y_view;
i gave grants to all user , but when i try this query with x user as select * from z.z_view get this message ORA-01031: insufficient privileges;
attention that connect as x and try select * from z.z_view
i have created a context from schema 'Schema1' using "accessed globally" option and created on package to set the values for conext. It is working fine.
When i deploy the same package on schema2 (remember the context is on schema1) and try to execute it on schema2 then it is giving me the following error.
Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production
SQL> exec krishna_pkg.MyProcedure
BEGIN krishna_pkg.MyProcedure; END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 90
ORA-06512: at "LGE2008DEV.KRISHNA_PKG", line 6
ORA-06512: at line 1
I am facing problems during login through sqlplus prompt.
It occurs in all the Linux boxes, with 10g and 11g databases, whereas in Windows it works good.
Sqlplus / as sysdba works good ( So there is no problem in OS Authentication)
Sqlplus sys/xxxx@SID as sysdba works good( Ther is no problem with password file)
But Sqlplus /@SID as sysdba is not working, It gives me an error message whereas in my windows box it works without any problems.
Error: ORA-01031 : Insufficient priveleges
I verified the service id entry in tnsnames.ora, i did not find any problem.
I've some metadata tables on one schema (abcref@db1) and users updates this table everyday. I need to replicate these tables to other schemas on same database (defdev@db1) and different database (deftest@db2) everyday. So i created materialized views on target schemas and refresh these through a pl/sql procedure. Now i'm getting error while refreshing the materialized view from defdev@db1 and the materialized view refreshes successfully from deftest@db2.
Granted select access on abcref@db1 tables to defdev@db1 and deftest@db2 tables via role.
Getting below error from defdev@db1 schema.
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 361
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 443
ORA-06512: at line 1
Table on abcref@db1 schema
===========================
SQL> create table REF_PROD_CD
2 (
3 prod_cd VARCHAR2(5),
4 division_cd VARCHAR2(1),
5 brand_cd VARCHAR2(2)
6 );
[code]....
Now Using below procedure to refresh materialized views from Target schemas.
SQL> CREATE OR REPLACE PROCEDURE PR_REFRESH_MV IS
2 BEGIN
3 DBMS_MVIEW.REFRESH('REF_PROD_CD','C');
4 END;
5 /
Procedure created
I can not login my db using tnsname,how can i do?
SQL> connect / as sysdba
Connected.
SQL> connect sys/sys@dup_oracl as sysdba
ERROR:
ORA-01031: insufficient privileges
I am getting a strange error while trying to create an MV.
<b><p>
Error report:
SQL Error: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1613
ORA-06512: at line 1
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if
[code]....
from sysdba i grant to my user hospital creat any synonym but give me this error why ?
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> grant create any synonym to hospital
2 ;
Grant succeeded.
SQL> conn hospital
Enter password:
Connected.
SQL> create public synonym Sur
2 for surgeries;
create public synonym Sur
*
ERROR at line 1:
ORA-01031: insufficient privileges
create view TodaySurgeries
as select s.surgery "Surgery", p.full_name"Patient Name",e.full_name"Doctor Name",
f.floor_id"FloorID",r.room_id"RoomID",
to_char(s.surgery_date,'dd-mm-yyyy hh24:mi:ss')"Surgery Date"
from floors f,rooms r,employees e ,patients p, surgeries s
where f.floor_id=r.floor_id
and p.patient_id= s.patient_id
and r.room_id= s.room_id
and s.doctor_id= e.employee_id
I had been granted to the user grant session and resource
but the error is
create view TodaySurgeries
*
ERROR at line 1:
ORA-01031: insufficient privileges
how to grant compile access for stored procedures..? I got execute access so that i can execute procedure from another user but not able to save/modify once i edited.
i am trying to compile using SQL developer. Error Message :Error: ORA-01031: insufficient privileges
When i try to copy a table within the database i get insufficient priv error.
SQL> COPY FROM JACK@JACK -
> CREATE T -
> USING SELECT * FROM JACK.T;
Enter FROM password:
Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
ERROR:
ORA-01031: insufficient privileges
what privilege is required to perform this copy command ?
When I try following SQL to retrieve records in some table XXXXX in the past point in time:
select * from XXXXX as of timestamp systimestamp-(6/24);
I am receiving following error:
ORA-01031: insufficient privileges
Without "as of timestamp" clause, it does run fine.Which privilege do I have to receive for above to work?
i am unable to login to oracle 10g as 'sys' as sysdba it is throwing an error like ORA-01031 insufficient privilidges for sys.but when i connect to database with username=system and password = oracle i am able to connect to database.
i have installed oracle 10g database on windows.so how should i resolve this error so that i can connect to the database as 'sys as sysdba'.
I installed Oracle 11g client and set the ORACLE_HOME and tns_admin env variables.I installed the pl/sql developer, but unfortunately after installing , i am unable to see any database details in the drop-down list of pl/sql developer.
View 4 Replies View RelatedMy primary objective was to compare objects in schemas in two different databases and find out the differences, Execute DDL's in the database where objects are missing and syn schemas in two different databases. So I need to compare schemas in databases. make a comparison of database objects existing in schemas in two different databases. I'd like to see if I can get a list of pro and cons between Toad and SQL Developer for comparing schemas pros and cons. navigation in SQL Developer to compare schemas.
Connect to Source
Connect to Target
Compare schemas with different object types
Find out differences
Generate DDL's for the missing objects or for the objects in difference report
Run them in missing instace(Source/Target)
Make sure both are in sync.
i have oel installed on my parallel Virtual machine.
i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.
my os is windows7 32 bit.
We have oracle server 10g in my office, in which i need to login through isqlplus(through iexplorer) in my system. how to set it.
View 5 Replies View RelatedI just got a new widescreen monitor and i want my sql*plus output to fill the whole page. I added the 'linesize 999' to my login.sql file but the line length only goes 100 characters across. It doesnt matter what kind of query or function i run. Still only 100 characters across. what else can i be missing?
View 16 Replies View RelatedI wanted to restrict the Users to login to DB using Application like TOAD or PL/SQl Developer .
But the users can login to DB using sql*plus.
We can get this info once user looged in to DB.
SQL> select SID,USER#,USERNAME,SERVER,MODULE from V$SESSION where USERNAME='LIVE4LEARN';
SIDUSER#USERNAMESERVERMODULE
12418265LIVE4LEARNDEDICATEDSQL*Plus
23018265LIVE4LEARNDEDICATEDPL/SQL Developer
43718265LIVE4LEARNDEDICATEDPL/SQL Developer
54018265LIVE4LEARNDEDICATEDPL/SQL Developer
Can we make this check done before login process and allow users to login when module not in ('TOAD','PL/SQL Developer').
ORA-00604:error occured at recursive SQL level 1
ORA-20501:Warning: Login Using <UNAME> Prohibited, Please contact GSD/DB-Services
ORA-06512: at line 73
I'm encountering the above msg while connecting to oracle through TOAD. While connecting through SQL * Plus I find no issues.
I'm using TOAD for Oracle 9.0.1.
I'm trying to connect to my DBs.I installed Oracle Client 10g, but PLSQL Dev. 7.1.4 doesn't find my tnsnames.ora.
View 4 Replies View RelatedI am using PL/SQL Developer.When i am trying to login with PL/SQL Developer i am getting the error
ORA-12514:TNS:listner does not currently know of service requested in connect descriptor
How to solve this one?
I instaledl Oracle Database 11g in my PC and try to login to it. I am able to log to it via SQLDeveloper but I can not login via SQLPLUS and I got ORA-12154. Here is my TNSname.ora and SQLplus.ora
# sqlnet.ora Network Configuration File: C:appmhakimjavadiproduct11.2.0dbhome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
[code]....
I try to login as SYS@sid AS SYSDBA When I login via TOAD, I am able to. However, as in (1), all my attempts to login from command-line SQL *Plus fails. The error I get is ORA-1031 Insufficient Privileges Even if I am on the physical server and try to run the SQL *Plus, I get the same error -- Insufficient Privileges
Here are the environment details:
Server: Windows Server 2008 R2
Server: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Client: Windows 7 Professional
Client: SQL*Plus: Release 11.2.0.1.0 Production
I am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.
PL/SQL developer
Version 8.0.1.1498
01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g
I am getting the below error
ORA-12154: TNS could not resolve the connect identifier specified
I am finding Oracle sql developer start up to be very slow.It takes more than 5 - 10 mins to startup.It seems for long startup.Its installed on Windows 7 machine in c: drive. Want to know what is causing it to be too slow.virus scanning, JVM startup.... ?
FYI
---------
Oracle Sql developer Version -- 3.2.20.09
Java(TM) Platform -- 1.6.0_43
How do i get tkprof trace file in sqldeveloper tool ? I donot have access sql in command mode.
View 5 Replies View Relatedwe have an issue on a server, where if we insert a value containing foreign characters from SQL+ we see it screwed up from SQLdev, whereas if we do the same insert from SQLdev it's then screwed up in SQL+.
All operations are performed on the DB server itself, SQLdev connection type is TNS and the entry being used is the same as the one used by SQL+.We checked v$nls_parameters and the values contained there are the same from both SQL+ and SQLdev.
sql developer tool which i am using to run query for every hour getting disconnected and to run a new query after an hour,i need to make a new connection again.Could you tell me an alternate way that should not disconnect the session in sql developer.
View 6 Replies View RelatedI have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.
I have given user name: ora; pswd: ora.
In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora
But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.
So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.
1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.
I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])
3] Is there any editor for practicing sql & pl sql queries. where I can download it.