...67891011
  • Privileges for DBA role

    In an Oracle 9.2.0.4 database I have a user with DBA as the default role. But I had to grant explicitly via "grant SELECT on ..." to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant...

    170519660 pointsBadges:
  • Problem with dblinks generated from Oracle Warehouse Builder

    Hi, I am using Oracle Warehouse Builder 9i to implement my data warehouse. Normally, it generates dblinks containing a TNS reference: create database link <hostname>@<connector> connect to <user> identified by <password> using '<hostname>'; But sometimes it generates...

    ActorJack0 pointsBadges:
  • Full Export on Win 2000

    I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can't get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well as EXP_FULL_DATABASE. Has anyone else...

    Oconnra0 pointsBadges:
...67891011

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following