database sql oracle
£10-20 GBP
着払い
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
プロジェクトID: #13869952
プロジェクトについて
アワード:
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 もっと
29人のフリーランサーが、平均£31 で、この仕事に入札しています。
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 もっと
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 もっと
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 もっと
I can do this. I have practical experience on 150+ oracle database administration including RAC, ASM and dataguard.