Oracle headaches: editing a user's permissions

pankaj_daga · May 11th, 2004, 03:52 AM

Hi everyone,

I am total newbie when it comes to Oracle, so please forgive me if this sounds really naive. I have installed Oracle 9i database system on my machine. I added a user and gave it some permissions using the Enterprise Console. However, I cannot find a way to edit that user. How can I do it? What oracle tool will allow me to do this? please help!

Sincerely,

Pankaj

Justin Cave · May 11th, 2004, 04:01 AM

The same console that lets you assign permissions (I assume this is the Oracle Enterprise Manager console) should let you edit permissions.

Alternately, you can use SQL*Plus, i.e.

Code:

GRANT <<privilege or role>> TO <<user>>
REVOKE <<privilege or role>> FROM <<user>>

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

pankaj_daga · May 11th, 2004, 04:41 AM

Hi,

Thanks for the reply!

I could not find anything in the Enterprise Console Manager. Also, can I view the privileges and roles of a user.

Thanks,
Pankaj

Justin Cave · May 11th, 2004, 04:58 AM

In OEM, choose Security | Users in the left-hand tree control to view the privileges assigned to a user.

From SQL*Plus, you can do

Code:

SELECT *
  FROM dba_role_privs
 WHERE grantee=<<user name>>

SELECT *
  FROM dba_sys_privs
 WHERE grantee=<<user name>>

to see the roles and privileges assigned to a user.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

pankaj_daga · May 11th, 2004, 06:19 AM

Perfect!

Thanks a lot Justin. Really appreciate it.

Pankaj