When user A creates a procedure and grants execute permissions to user B, user B can execute the procedure (obviously), but he can also see the code (in ALL_SOURCE view).
When user A creates a procedure and grants execute permissions to user B, user B can execute the procedure (obviously), but he can also see the code (in ALL_SOURCE view).
Lately I had a weird problem with one of my customers regarding timezone in the database. They copied a database server from US (eastern time zone) to Europe (GMT) and
Databases are designed to hold data and retrieve it, so they are optimized to run queries. Over the years I’ve seen quite a few cases where the developers did things
This is the last part of the series, and as promised I’ll have a script to perform database export. If you wish to read the first posts, here they are:
I usually write about conferences quicker, but didn’t manage to find the time so I’m a week late. Last week I spoke at VODD (Vancouver Oracle Developers Day) here in downtown
lately I wrote a couple of posts about bash scripting for DBAs (part 1 and part 2). I promised to post an example script as well, and I will. But
If you are using Data Guard and standby databases, you probably need to do stuff based on the database role. For example, have some services start on the primary database,
If you’ve read my post about 12.2 new features and liked it, you will like this one as well. I’ve recently looked at presentations from OOW16, and found one by
A few weeks ago Tim Hall (the oracle-base guy) came up with the idea to have an appreciation day for OTN. As I’m in western Canada, I’m probably in one
This was my first time in Portland, OR, and I’ve hardly seen it. I arrived On Sunday, October 9th, for the October 10th conference in down town.