Results 1 to 3 of 3

Thread: I've a doubts

  1. #1
    Join Date
    Feb 2004
    Location
    SP
    Posts
    2

    Red face Unanswered: I've a doubts

    Hi .

    I need that a user don't have permissions to Create objects in Database.
    The user (XPTO) don't have grants to CREATETAB and CREATEIN and USE TABLESPACE .
    but when ,"in test ", I make a connect with this user (XPTO) and make a create table ( ... ) , the table will be created .
    what can I do to don't allow that user (XPTO) can create an object in a Database .


    Thanks.

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: I've a doubts

    Revoke the privileges from PUBLIC. By default PUBLIC has the privileges to connect to database, create table etc. thus every new user inherits them, so revoking from PUBLIC will solve your problem.

    dollar

    Originally posted by Bigas_fabio
    Hi .

    I need that a user don't have permissions to Create objects in Database.
    The user (XPTO) don't have grants to CREATETAB and CREATEIN and USE TABLESPACE .
    but when ,"in test ", I make a connect with this user (XPTO) and make a create table ( ... ) , the table will be created .
    what can I do to don't allow that user (XPTO) can create an object in a Database .


    Thanks.

  3. #3
    Join Date
    Feb 2004
    Location
    SP
    Posts
    2

    Thumbs up

    Thanks dollar.

Posting Permissions

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