We can't use the sys user on our customers db. It it possible to install without and grant some?

asked 16 Dec '16, 04:28

ulrichmueller's gravatar image

ulrichmueller
111
accept rate: 0%


Hi Ulrich,

You can use manual installation scripts to install Formspider if you dont know SYS password. Simply download the scripts from Formspider download page and give the scripts need to be run with SYS to the DBA who know SYS password. So that they can see what is going on under the hoods and run it.

Just remember to run scripts in the order specified in the help file of scripts.

Kind Regards
Serdar

link

answered 16 Dec '16, 08:07

Serdar's gravatar image

Serdar ♦♦
100k4
accept rate: 14%

So we are not allowed! to install things as sys.

link

answered 16 Dec '16, 10:46

ulrichmueller's gravatar image

ulrichmueller
111
accept rate: 0%

Hi Ulrich,

In order to install Formspider, you need to create a database user and give it a few privileges. Technically, it is possible to create this user and give it the reqired privileges even without using the SYS user. As long as the user you are running the scripts in has enough privileges to execute the DDL's in the installation scripts, you should be OK. So, no the installation does not have to be done by the SYS user.

Kind Regards, Yalim

(16 Dec '16, 13:15) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×4

Asked: 16 Dec '16, 04:28

Seen: 155 times

Last updated: 16 Dec '16, 13:15


© Copyright Gerger 2017