Re: Minimum privileges for users

From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com.invalid>
Date: Tue, 17 Nov 2009 13:34:47 +0100
Message-ID: <hdu597$m7c$2_at_news.eternal-september.org>



vsevolod afanassiev escribió:
> CONNECT and RESOURCE are sufficient, you don;t need to grant anything
> else. Basically users need following privileges:
> - CREATE SESSION (included in CONNECT)
> - CREATE TABLE (included in RESOURCE)
> - Quota on the tablespace where tables are going to be created -
> RESOURCE has UNLIMITED TABLESPACE
>
> So to grant bare minimum you need to do something like:
> - CREATE USER ABC
> - GRANT CREATE SESSION, CREATE TABLE TO ABC
> - ALTER USER ABC QUOTA UNLIMITED on USERS

Do you mean that assigning the RESOURCE role is equivalent to assigning the CREATE TABLE privileges? Does it include permissions to create other objects like sequences or views?

-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--
Received on Tue Nov 17 2009 - 06:34:47 CST

Original text of this message