How to limit USERS ability to Create Tables

From: Martin Douglas <dafis_at_ppp.test.jccbi.gov>
Date: 1996/11/19
Message-ID: <NEWTNews.848470732.5062.dafis_at_ppp.test.jccbi.gov>#1/1

Howdy,

I have just run into a problem on my inquiry only system. I have a large Data Warehouse (100Gig) in which I have a user that just created his own table in his default tablespace "USER_TBS". I have granted all users one ROLE that I defined. This ROLE has 'connect' and 'select *' on views I developed. This user does have a default tablespace 'USER_TBS' and a default temporary tablespace 'TEMP', But he has '0k quota' on each of these tablespaces.

How did he create this user defined table without me giving 'create table' privileges and how do prevent this in the future.

Thanks for you time

Martin Douglas Received on Tue Nov 19 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Dug Birdzell: "Inserts to one table by many users"
Previous message: Bill Wood: "Problem restarting an instance after interrupting sqlload"
Next in thread: N Prabhakar: "Re: How to limit USERS ability to Create Tables"
Reply: Sridhar Subramaniam: "Re: How to limit USERS ability to Create Tables"
Reply: dafis_at_ami500b_md.mpb.jccbi.gov: "Re: How to limit USERS ability to Create Tables"
Reply: Vikas Agnihotri: "Re: How to limit USERS ability to Create Tables"
Reply: N Prabhakar: "Re: How to limit USERS ability to Create Tables"
Maybe reply: janet: "Re: How to limit USERS ability to Create Tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message