Home » RDBMS Server » Enterprise Manager » I don't see any available roles, system privileges for any user including SYS/SYSTEM.very urgent?
I don't see any available roles, system privileges for any user including SYS/SYSTEM.very urgent? [message #68645] Fri, 14 May 2004 07:20 Go to next message
raman
Messages: 66
Registered: February 2000
Member
Hi

I don't see any available roles, system privileges for any user including SYS/SYSTEM.....but I'd see granted roles....Basically, I was trying to grant DBA role, which I don't find it....eventually, I found nothing is there in available roles/system privileges....

Any clue?? I think it should be solved ASP..

I'd appreciate your help

-raman

Report message to a moderator

Re: I don't see any available roles, system privileges for any user including SYS/SYSTEM.very urgent [message #68647 is a reply to message #68645] Mon, 17 May 2004 03:32 Go to previous messageGo to next message
ASIF ALI SHAH
Messages: 2
Registered: May 2004
Junior Member
u can use this command from sys/system user to grant dba writes to any user.

grant dba to new_created_user;

Report message to a moderator

Re: I don't see any available roles, system privileges for any user including SYS/SYSTEM.very urgent [message #68691 is a reply to message #68645] Tue, 06 July 2004 02:28 Go to previous message
amar
Messages: 14
Registered: October 2000
Junior Member
check with the following stmntis
select * from DBA_TAB_PRIVS

or

select * from user_tab_privs

depending on ur requirements

Report message to a moderator

Previous Topic: Help required in Creating / scheduling job with OEM
Next Topic: Peculiar problem with OEM related to login.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 20:48:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.