revoking drop table priviliege

From: <chandrasekar_at_my-dejanews.com>
Date: Tue, 26 Jan 1999 04:10:42 GMT
Message-ID: <78jf7s$tep$1@nnrp1.dejanews.com>

Hi, I have two questions for ORACLE DBA INTELLECTUALS : 1. Is it possible to revoke only a drop table priviliege from the user who can connect to database, query tables and do transactions . 2. Is it possible to restrict a user from dropping and creating tables based on the terminal numbers;

To eloborate the environment , We are running ORACLE 8.0.3.0 in winNT platform . We have an user 'test1' where all the other users can query this schemas table but the users should not drop or create any tables of their own in 'test1'. Particularly the users working in terminal c100,c101,c102 & c103 should not be given priviliege for creating or dropping tables .

Your valuable inputs are greatly appreciated . thankx in advance
cheers
CHANDRASEKAR -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 25 1999 - 22:10:42 CST