Current Position:Home > DBA Proviledge and Access Level

DBA Proviledge and Access Level

Update:11-30Source: network consolidation
Advertisement
Dear all,
Issue: DBA should have the required access level to maintain the database without having access to the business data in certain schema (user)
Details: I am looking for a solution to enable the DBA to do all his administration work and maintain the database and at the same time he should not have any access to the data objects (specially the data in the tables) in certain schema in the database. The question is: How can I create a DBA then I revoke from him the access to the DB objects in certain schema?
Best Regards,
Abdo.

The Best Answer

Advertisement
Do not give the dba the DBA role; instead ceate your separate role, named, say SECURED_DBA, grant SELECT CATALOG ROLE, ALTER SYSTEM, ALTER DATABASE, etc., but not sweeping privs SELECT ANY TABLE, etc. This will help the DBA manage the database but not have access to the table data.
  • DBA Proviledge and Access Level Update:11-30

    Dear all, Issue: DBA should have the required access level to maintain the database without having access to the business data in certain schema (user) Details: I am looking for a solution to enable the DBA to do all his administration work and maint

  • How to change lookup code  with Access Level as 'System' Update:10-11

    Hi, I need to append new lookup codes in a lookup type having access level as 'SYSTEM'. Is there any standard way to do the same or just updating the customization level column will do ? Please let me know if you have any solution for this. Regards G

  • What is the use of access level Update:10-11

    Hi Experts, What is the access level and what is use of each option in access level 1  Application 2  Superior component 3. Top Component 4. Sap 5. Global and in Details section what is the use Properties tab 1. Application Component 2. Software Comp

  • How to include group access level in a ws call Update:10-11

    I want to include a Group Access Label in a Permission for a Course using an iTunes web service call. I don't see how to do this in the docs. (The example in iTunesUAdministratorsGuide.pdf at page 111 doesn't include the Group Access Label. And it's

  • The best way to implement user's access level via Servlet & JSP (or more)? Update:10-11

    Hi all, I am trying to implement user's access level in an application to allow certain access to certain page or components within a page (buttons, etc.). From my experience with JSP, Java, servlet, I am think of having the jsp/servlet to check for

  • Is there an "Access Level" field on the "Send for Shared Review" screen (Pro X)? Update:10-11

    I'm using Pro X, but haven't come across the "Access Level" field expalined in this on-line video http://tv.adobe.com/watch/learn-acrobat-x/getting-started-the-basics-of-reviewing/ Is this something you can enable?It's only available if you sele

  • Restrict certain function based on access level Update:10-11

    I'm working through an approval process with Office 365 SharePoint Lists and Infopath, and I want certain people to be able to submit items in a Sharepoint list on behalf of someone else. So, the boss might have her assistant post news for her, but h

  • Access levels in dreamweaver cs4 Update:10-11

    Hi, I have been playing around with dreamweaver cs4 using the tutorials and videos i have thanks to you guys. I created a simple login mysql database and used the login features within dreamweaver cs4 which was great and so simple. I have came across

  • Managing "Access Levels" on a domain level from Lync 2010 client Update:10-11

    Hello, Our company moved from Office Communicator 2007 R2 clients to Lync 2010 clients. Previously in Office Communicator 2007 R2 client, it was possible to set default Access Levels for complete domains (instead of individual users only), using the

  • Help creating apple script to create folder and set access levels Update:10-11

    I'm trying to create folders in FileMaker Pro using apple script and need some help in setting the access level for the folders.  I want to set both Staff and everyone to Read and Write access.   Secondly I would like to have a function key set on th