A: Not necessarily. Actually, we recommend that, instead of the DBA role, you grant discrete privileges; that grants everything! Within Toad, we try to use USER_ and/or ALL_ where possible, but a few things like tablespaces only offer DBA_ views. In those cases, all you would need is the SELECT_ANY_CATLOG role.
Related Articles
Server Pools: What’s New in Oracle 12c?
Overview Oracle Clusterware 11g release 2 laid the foundation of policy-based cluster management by introducing server pools, which are logical groups of servers hosting the resources managed by Orac...
Monday Coffee 2017-03-13
Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for me but am looking forward to it. I’ll get my slides and demos uploaded here at some point. I’ve been...
SQL SERVER – SQL Browser not Starting. Error – The SQL Configuration...
Today’s blog is originated from a blog interaction. After hardening a server, my friend was not able to start SQL Browser service. When we try to start from services, we get below standard error, whic...
