database sql oracle
£10-20 GBP
Paiement à la livraison
Task 6 (Securing the Database)
It is not desirable to allow all the users to be able to anything to any part of the database. For example, the sales manager may need to view and update customer orders but they do not need access to works orders. Conversely, the works manager may need to view and update works orders but they do not need access to customer orders.
Create a new user profile with restrictions you think are appropriate
Create a new user and assign name, password, new profile and storage quotas
Create three views based on one or more tables
Issue the new user the appropriate privileges to query and insert into the view
Issue your new user the required privileges to connect and do the following work: o To be able to only query (read) view A o To be able to query and insert into view B o To be able to do all tasks on view C
To save the DBA time, wrap all these privileges into a single role Remove all the previously issued privileges from your user
Replace them by issuing the new role to your user
Nº du projet : #13869952
À propos du projet
Décerné à:
I worked as an Oracle DBA for 3+ years working on projects with requirements the same as yours. I maintained users, roles, privileges, ran DDL to create views, tables, indexes, etc. I ensured that users could only ac Plus
29 freelances font une offre moyenne de 31 £ pour ce travail
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o Plus
Sr. Software Developer having 7+ years experience. Technology : Windows Application Web Application Mobile Application Skills : C# .Net, MVC , PHP, VB .Net, HTML, CSS, Javascript, Jquery, Anguler Js, Mobil Plus
HI, I am expert in SQL, DB Modeling, Oracle Certified Professional. Can do the task as per your requirements. .
I have over fifteen years of database design, development and administration experience using oracle database (8 to 11g) and different other tools. Started as a trainee developer to work with forms and reports and that Plus
Hi, I'm Oracle SQL developer with 3+ years of professional experience. Please contact me if you have any questions. Best regards, Alen
I have good database administration and software development experience which makes me well suited for this project.
Hello, I have 5+ years of experience in Oracle database development. I have some free time after my office hours so want to start some freelancing.
Have got extensive experience in DBA, ETL and data processing. Actively looking for first project on freelancer. Ready to put extra efforts if required with minimum possible $. Here is how I propose to build the DBA Plus
I can do this. I have practical experience on 150+ oracle database administration including RAC, ASM and dataguard.
