database sql oracle
£10-20 GBP
Paid on delivery
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
Project ID: #13869952
About the project
Awarded to:
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 More
29 freelancers are bidding on average £31 for this job
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 More
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 More
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 More
I can do this. I have practical experience on 150+ oracle database administration including RAC, ASM and dataguard.