Privileges!URGENT!

[amitstora]

Hi all!

Queries:

1.If connect,resource roles are granted to newly created users,is there a possibility to revoke CREATE TABLE PRIVILEGE from such a user.If so how?

With regards,

Amitstora.

[santoshym]

Hi Amit,

You can use the following statement to revoke privileges of the user

1) login as user system or sys

2) Type the following statement to revoke the users privilege

revoke resource from username;

Regards

[akkerend]

If the user has the roles CONNECT and RESOURCE, revoking the privilige from the user does not help. Revoke the roles from the user and grant the privileges to the user that (s)he needs e.g. CREATE SESSION and ALTER SESSION

[santoshym]

Hi Amit,

Try the following statement after logging in as sys or system you will understand what privileges are associated to connect and resource

select * from dba_sys_privs where grantee = 'CONNECT' or grantee = 'RESOURCE'

Hope this helps you

Regards

[sambavan]

Grant the privileges explicitly to the user. If you have more than one user, then go ahead and create a role on those privileges that you would like to grant to the user and grant that role to those users. This way you can manage things easily.

Sam