help related to privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: help related to privileges

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    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


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    thanks pando

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width