Search posts, tags, users, and pages
Thanks for sharing!
I am wondering which user is used for the database connection dev_admin? SYS?
Hi Michael. To which part of my blog post is your question related to?
Yeah, sorry, good point. I mixed it up with your Ksope presentation slides and I'm refrencing to slide 16 there. Sorry, if this is the wrong place to ask.
Michael Abele No problem. Slide 16 just show my pre-configured connections in SQL Developer extension for VS Code.
Rafal Grzegorczyk Thanks for your response! My question is: what user do you use for these connections? A proxy user would work, but then this user needs to have all object priviliges to all schemas included in the SQLcl projects project. And if a new object is created, this has to be granted to get the projects export working... so that's why I'm wondering if you use SYS as user for your "Dev admin" connection?!
Michael Abele dev_admin is an ADMIN user at OCI, so it will always have the required grants. For exports, you should always use a user who has the privileges required for the schemas included in the project. For OCI, it can be ADMIN, for non-premise, it could be a user with a role assigned ( and that role should have everything required). Basically, is up to you.
Rafal Grzegorczyk thanks a lot for your detailed explanation!