https://community.hpe.com/t5/operating-system-hp-ux/oracle-user/m-p/3897850#M771869 Hello, <BR />I want to create a user in a Oracle9i Database who can create tables but not drop them. <BR />But if I grant to the user the privilege "CREATE TABLE" I can drop the table because that privilege is included in the creation one. <BR />And If I create a user with the only privilege "CREATE SESSION" and then I create a table in it with the system user, I am able to drop it as well from the first user...<BR />Thanks! Tue, 14 Nov 2006 05:07:18 GMT Iciar 2006-11-14T05:07:18Z https://community.hpe.com/t5/operating-system-hp-ux/oracle-user/m-p/3897850#M771869 Hello, <BR />I want to create a user in a Oracle9i Database who can create tables but not drop them. <BR />But if I grant to the user the privilege "CREATE TABLE" I can drop the table because that privilege is included in the creation one. <BR />And If I create a user with the only privilege "CREATE SESSION" and then I create a table in it with the system user, I am able to drop it as well from the first user...<BR />Thanks! Tue, 14 Nov 2006 05:07:18 GMT https://community.hpe.com/t5/operating-system-hp-ux/oracle-user/m-p/3897850#M771869 Iciar 2006-11-14T05:07:18Z