help related to privileges

[shailendra]

hi friends I am facing one problem of privileges

I have created a user I have grant it connect rights as well as create table rights but I havn't grant it create sequence but it is allowing it to create sequence.

also when I am tring to revoke the role it is saying that it is not granted.


What do I do to stop creating sequence.
Thanks in advance

[pando]

connect is a role which includes

ALTER SESSION
CREATE CLUSTER
CREATE DATABASE LINK
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW

privileges

if you wanna revoke create sequence you would have to revoke the connect role but that will revoke all privileges above

[shailendra]

thanks pando