Click here to Skip to main content
15,909,822 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,
Is there any way to find whether a logged in user is a sysdba o not?
I used the following to connect to the db:
C#
OracleConnection oraConnection = new OracleConnection();
            string conString = @"Data Source =orcl;User Id =test;Password =test";
            oraConnection.ConnectionString = conString;
            oraConnection.Open();


Please guide me through this matter.
Posted
Updated 31-Aug-11 5:45am
v2

1 solution

sysdba is a privilege, not a role. Here's some code that might work:

http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900