Some Useful SQL Queries

1. To see how many users have been already assigned SYSDBA privileges in a Database.

select * from v$pwfile_users;

2. Access SYSDBA to a user.

grant SYSDBA to scott;

3. Revoke SYSDBA to a user.

revoke SYSDBA to scott;