Oracle User Creation Script

7 years ago

Hi ‌, please have a look at user guide for SIOS, chapter 2.3 lists all required objects: https://snowprod.service-now.com/support?id=kb_article_view&sys_kb_id=d50e7ddb1b0e33405586cbfe6e4bcb72 We do not provide a scripte since the required permissions can potentially change with the releases and they did in the past. To create a script yourself I would suggest the following method: 1. Copy all objects from the SIOS documentation to an editor, e. g. Notepad++ 2. Insert before every object the string "grant select on " 3. Insert after every object " to <insert your desired Oracle username here>;", e .g. "to OSCAN;" 4. Insert header as frist line: "Create user <insert your desired Oracle username here> identified by <put your password here> ;" 5. Allow database login for the user, so add as second line after "Create user" line: "Grant create session to <insert your desired Oracle username here>;" If using database vault, remeber to take chapter 2.4.1 into account! BR Michael

Expand Post

Community Manager (Flexera Software)
7 years ago
Hi ‌, please have a look at user guide for SIOS, chapter 2.3 lists all required objects: https://snowprod.service-now.com/support?id=kb_article_view&sys_kb_id=d50e7ddb1b0e33405586cbfe6e4bcb72 We do not provide a scripte since the required permissions can potentially change with the releases and they did in the past. To create a script yourself I would suggest the following method: 1. Copy all objects from the SIOS documentation to an editor, e. g. Notepad++ 2. Insert before every object the string "grant select on " 3. Insert after every object " to <insert your desired Oracle username here>;", e .g. "to OSCAN;" 4. Insert header as frist line: "Create user <insert your desired Oracle username here> identified by <put your password here> ;" 5. Allow database login for the user, so add as second line after "Create user" line: "Grant create session to <insert your desired Oracle username here>;" If using database vault, remeber to take chapter 2.4.1 into account! BR Michael
Expand Post

Related Product Forums