查找用户的角色 [英] Finding the role of a user

问题描述

大家好，
有什么方法可以确定登录的用户是否不是sysdba吗?
我使用以下内容连接到数据库:

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:

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.

推荐答案

sysdba是特权，而不是角色.以下是一些可能有效的代码:

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

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[^]

这篇关于查找用户的角色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！