Re: revoke access to a tablespace for a user

From: MSHANKR <mshankr_at_aol.com>
Date: 24 Apr 1999 10:32:28 GMT
Message-ID: <19990424063228.10815.00000917@ng15.aol.com>

Eric:
Hi,

Access to tablespaces can be controlled by limiting quotas for users, and when you do use quota method, the default for all tablespaces will be zero. you will be forced to set quotas for each user and may then like to use the roles approach.

alter user user_name quota "N"k on tablespace tablespace_name.

If i have interpreted your question incorrectly or you need more details, write back on "mshankr_at_aol.com"

Thanks
Manu Shankar Received on Sat Apr 24 1999 - 05:32:28 CDT