Stack Overflow
Stack Overflow

Questions tagged [sysdba]

45 questions
0
votes
2 answers

Restrict user to use ‘conn /as sysdba’ from OS Level

It is possible to allow the use of sqlplus at OS level to a certain user or group, but restrict the use of "sqlplus / as sysdba" to the same user o group?
MasterC
  • 173
  • 1
  • 1
  • 13
0
votes
0 answers

"sysdba" login in Sql Server 2014? Why?

I have a "sysdba" login account among the logins in my SQL Server 2014 instance, and I'm not sure why. I can't do anything with it (change the password, user mappings etc) -- I just a get a "user already exists" error, or the changes just don't…
Robert Murrell
  • 171
  • 2
  • 12
0
votes
1 answer

What is idle DB session? When to terminate these sessions?

What is idle DB session? What factors we have to look into before terminating an idle DB session? When can we terminate it?
Puja
  • 1
  • 1
  • 4
0
votes
2 answers

Access table user in sysdba privilege

I created some tables as a normal user, and when I change the privilege to sysdba I didn't fiund my tables! I get this message: table or view does not exist This is what I do: First of all, with a normal user's privilege I create tab1: create table…
Kati Dev
  • 25
  • 1
  • 3
  • 10
0
votes
1 answer

group two tables result without duplicate results

I am trying to get roles and privileges from two different tables for a specific user. My query is this: Select r.grantee, r.granted_role , s.privilege From dba_role_privs r, dba_sys_privs s Where r.grantee=s.grantee and r.grantee=(select username…
Majd Alsheikh
  • 1
  • 4
0
votes
1 answer

what is function of default tables in ORCL database

I installed oracle 10g software and connected to ORCL database in SQL Developer. when I expand the tables section I see a lot of tables there like in image below. What are these tables for? HOw can I create a database that does not have these…
WAQ
  • 2,556
  • 6
  • 45
  • 86
0
votes
1 answer

Add privilege on Oracle ACL file without SYSDBA access

I´m trying to consume a Restful Service on Apex but I am getting the following error: Unauthorized URL I managed to fix it before by creating an ACL file, adding the URL of the RESTful service and adding privileges to the APEX_PUBLIC_USER. But…
user2730285
  • 33
  • 1
  • 6
0
votes
2 answers

VBScript Connection oracle in sysdba

I need to connect in sysdba on Oracle from Vbs. I use this command to connect on my database set cn = CreateObject("ADODB.Connection") set rs = CreateObject("ADODB.Recordset") ConnectionString ="Provider=OraOLEDB.Oracle; Data…
Galene
  • 39
  • 3
0
votes
0 answers

ORA-12528 and ORA-12505 error on oracle database

Its been one week since i last try to run my final project that i worked in my last internship at some banking company. Suddenly, my webapps (java project) in eclipse cant start. In the log it says that it failed to make a connection to the oracle…
Nico
  • 323
  • 2
  • 5
  • 17
0
votes
1 answer

Unable to login to Sqlplus as sysdba: "ORA-01031: insufficient privileges"

I can't login to sqlplus using: sqlplus / as sysdba All the time, it gives me: ERROR: ORA-01031: insufficient privileges If someone could help me, that would be awesome.
Tibo
  • 53
  • 2
  • 6
0
votes
2 answers

how to move undo datafile in running database without disturbing transactions?

Unfortunately one UNDO data file was misplaced in wrong location when I was adding space. I want to move that file to correct location. As it is Production database, I don't want to disturb the ongoing transactions. Can I offline that particular…
Neelima
  • 27
  • 1
  • 6
0
votes
2 answers

Login as SYS user to Oracle 11g from .NET

Using the Oracle Data Provider for .NET, my application connects to the database using the privileged SYS user. The connection string is as follows: Data Source=MyTnsName;User ID=sys;Password=MySysPassword;DBA Privilege=SYSDBA This works fine with…
Jens Bannmann
  • 4,845
  • 5
  • 49
  • 76
0
votes
2 answers

In my oracle database, one tablespace gives out of space alert frequently even am adding space, How to know the cause?

In my oracle database, one tablespace gives 'out of space' alert frequently even am adding space, How to know the cause? Intially I created tablespace with size 1GB, now it's size 4GB. How to know the reason, when am querying for used object for…
Neelima
  • 27
  • 1
  • 6
0
votes
3 answers

Oracle running script

I am using Oracle Sql Developer I have a huge script that creates tables, indexes, primary key constraints and such. my DB name is: dbo_other I logged into this dbo_other as sysdba. If I run my script then tables do not show up on left panel under…
Drake
  • 2,331
  • 3
  • 19
  • 17
-1
votes
1 answer

I inatalled Oracle db 19c and login as user sys as sysdba the error,"ORA-12154: TNS:could not resolve the connect identifier specified" accured

Error "ORA-12154: TNS:could not resolve the connect identifier specified" accuring while logging in as "sys as sysdba" with password . But then I read an article saying that,"admin privilages let's a sysdba login without a password." and I tried…
Paras Bartwal
  • 15
  • 3
1 2
3