Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> grant command needed

grant command needed

From: Paul Chang <pch_at_pinnacle.>
Date: 12 Oct 1998 03:53:40 GMT
Message-ID: <6vrug4$kd0$1@ebaynews1.Ebay.Sun.COM>

Hi,
I am new to Oracle.
Our developers need the following previlege for db design. Which command is necessary for them?
thanks,
Paul.


Role                    connect
session privileges      Alter session
                        Restricted session
                        create session

Data Definition Priv.   Create Cluster
                        create Database Link
                        create any link
                        create any procedure
                        alter database
                        alter rollback segment
                        create rollback segment
                        create sequence
                        create snapshot
                        create synonym
                        create table
                        alter tablespace
                        drop tablespace
                        Unlimited tablespace
                        create tablespace
                        manage tablespace
                        create trigger
                        create view
Data control Priv.      alter system




Received on Sun Oct 11 1998 - 22:53:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US