Database Oracle sql

Cancelled Posted 6 years ago Paid on delivery
Cancelled Paid on delivery

Task 6 (Securing the Database) 10 marks 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

Database Programming Oracle SQL

Project ID: #13868418

About the project

18 proposals Remote project Active 6 years ago

18 freelancers are bidding on average $516 for this job

juniadsarfraz

Designed and Developed many databases and erds. Contact me ASAP with more details. I am interested. Thanks,, Junaid

$620 USD in 14 days
(9 Reviews)
5.8
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discuss More

$555 USD in 10 days
(3 Reviews)
5.3
jagdishbhatt38

I have more than 8 years of experience in IT industry.I have worked on .net(c#net,vb.net,asp,asp.net,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Awaiting for you More

$400 USD in 3 days
(30 Reviews)
4.8
prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$773 USD in 20 days
(4 Reviews)
4.6
AltiuseCreaton

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them . Hope the More

$1666 USD in 23 days
(1 Review)
3.7
webbookstudio

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so More

$400 USD in 6 days
(1 Review)
3.4
Precious01

Hi, I am a certified oracle database administrator with 4+ years experience. According to your project description, I understand you need to assign roles to the database users and grant/restrict privileges. I can help More

$250 USD in 5 days
(2 Reviews)
1.6
allwriter4u

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SIMU More

$250 USD in 10 days
(1 Review)
1.0
techcrunch2

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu More

$652 USD in 6 days
(0 Reviews)
0.0
bhramarsil

Hi, Please let me know if you are interested to involve me. It seems the task is mostly about Database administration - would like to discuss in detail if you do feel like assigning me the task. Regards, Bhramar

$250 USD in 3 days
(0 Reviews)
0.0