ArcGIS Geo Database creation SDE User ___ Database

Using ArcGIS's SDE user scenario, if you cannot automatically create SDE users through ArcGIS, you will need to manually create them using the following SQL

--Create a geodatabase with all the following code (you must create a geodatabase named SDE!!!! ): Create user SDE identified by password;
--Basic permissions
Grant create session to SDE;
Grant CREATE table to SDE;
Grant create tablespace to SDE;
Grant CREATE view to SDE;
--Create a table space
Create Tablespace Sdespace
Logging
DataFile ' path \sdespace.dbf ' size 50M
Autoextend on
Next 10m maxsize 400m
Extent management Local;
--Specifies the user default tablespace (also specified when creating a user)
Alter user SDE default Tablespace arcspace;
--To create or upgrade the execution permissions required by the Geodatabase
Grant execute on Dbms_pipe to SDE;
Grant execute on Dbms_lock to SDE;
Grant execute on Dbms_lob to SDE;
Grant execute on dbms_utility to SDE;
Grant execute on Dbms_sql to SDE;
Grant execute on Utl_raw to SDE;


-Minimum permissions required by the Geodatabase administrator:
--create session,create sequence,create table,create trigger,create procedure
Grant create sequence to SDE;
Grant create trigger to SDE;
Grant CREATE procedure to SDE;
--SDE the permissions that users need to create a geodatabase in a SDE user scenario (SDE primary Geographic database)
Grant execute on Dbms_crypto to sde;--allows the creation of st_geometry types of MAP member functions
Grant create Indextype to SDE;
Grant create library to SDE;
Grant create operator to SDE;
Grant create public synonym to SDE;
Grant create type to SDE;
Grant drop public synonym to SDE;
Grant administer database trigger to SDE;
--Other required permissions known in the test (document description optional, actually required)
Grant unlimited tablespace to SDE;


--Other common optional permissions (not required to create a geodatabase, subsequent maintenance may be used, see the reference documentation):
--alter session, Plustrace, alter ANY index, analyze any, select any dictionary,
--create database link, create materilized view, restricted session,
--alter system, Select_actalog_role,
--(Oracle 10g and Advisor,create Job)