nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

which DB objects in oracle exadata needs user's admin rights.

SW_s8j18x

I am trying to install bitbucket in our company ystem, but facing issue when I select external database (which is oracle exadata in our case).

If I use ADMIN credential it works fine. But, in real time scenario, we can not use ADMIN account, this is prohibited in our environment. So I created a normal user and followed instruction as mentioned in Atlassian documentation (https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-oracle-776640379.html), but I found error.

2017-06-12 10:09:00,539 WARN [http-nio-9090-exec-7] @2JMMOQx608x17x0 12soj9v 0:0:0:0:0:0:0:1 "POST /setup HTTP/1.1" c.a.s.i.db.DefaultDatabaseManager An unexpected exception prevented validating the target database
com.atlassian.stash.internal.backup.liquibase.LiquibaseDataAccessException: Failed to obtain snapshot. Database type: oracle; nested exception is liquibase.exception.DatabaseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

I also figured that if I give admin access to the normal user it works fine. But we need to know the DB objects specifically those need admin priviledge to access, so that we can grant only those objects, not the entire database.

Accepted answers

All comments

Nic Brough -Adaptavist-

All of them. The user you use to connect to the database should have all rights on all tables.

Trying to give partial rights is possible, but it's a pain in the neck to work out, harder to maintain, and there is absolutely no good reason to do it.

SW_s8j18x

I have created new user as per https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-oracle-776640379.html.

-------------------------------------------

but from error mentioned in log, i.e.

Caused by: liquibase.exception.DatabaseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

I see it is expecting some table in the empty database. So need to know which specific table it is trying to access and why it is not able to create the table/view with normal user (as per instruction given in Atlassian page).

Nic Brough -Adaptavist-

Yes, it should have created all the required tables when you first installed it. If you were using the wrong account, then it may have set it up incorrectly and hence can't connect with the right one.

There may well be no way to fix this without really comparing a clean valid installation with your database.

You can try to do it without doing a full reinstall, but you need to read ALL of the error log to start to work out what might be missing, and bear in mind that because it can't read/write the tables correctly, that you may have lost data.

SW_s8j18x

Sorry for the confusion, I think the scenario is not well prescribed above.

FYI, I have installed the new Bitbucket server instance with bitbucket's own internal databse first(with no data yet). And now I want to connect it with external database .i.e. exadata(oracle).

I have followed the atlassian link to create "userone" on databse but its giving error while trying to connect.

The "userone" is normal user which has connect and resource access to database.

"userone" needs admin permissions on database ?

I seen that if I give admin access to the "userone" it works fine.

And if error suggest its "table or view does not exist" what are these tables or views, how can I find them. Please suggest.