Find Jobs
Hire Freelancers

Create a script to get list of users and permissions in an Oracle Database

$30-250 USD

Closed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
Hello, I need to create some scripts to get some information regarding users and permissions in Oracle Database (11g R2 and 10g) Basically I need two things: First the list of users and last logon date. Second, I need to get the list of permissions for each user - Access Privileges - Tables with Access - Procedures, Packages, Functions
Project ID: 17069611

About the project

39 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average $119 USD for this job
User Avatar
you can retrieve all type of users info from data dictionary as well as log minor can tell you each and every thing
$55 USD in 1 day
4.8 (79 reviews)
6.8
6.8
User Avatar
Hi, I read your requirement and understood to write some SQL queries to bring the results. You have stated clearly write an SQL to fetch the list of users and last long on time. The second query should fetch list of users with permissions on Tables and Access and also packages, procedures and functions. Please award this project, I will write these two SQL queries and will produce perfect result immediately. Thanks Paul
$60 USD in 1 day
4.9 (30 reviews)
5.4
5.4
User Avatar
Hi sir, nice to meet you, i can deliver an script for get all DBA information that you need, of course this script needs to run with high level account, but for the rest no problem. we can disccuss more details in chat, feel free to ask me ;)
$35 USD in 1 day
5.0 (18 reviews)
5.1
5.1
User Avatar
Hello, I am a developer with more than 18 years of experience. I have worked with oracle database all of my time, and I am well versed in Oracle administrative tables and views.
$50 USD in 1 day
5.0 (15 reviews)
4.1
4.1
User Avatar
I'm an Oracle DBA/Developer with over 15 years experience. This is actually a relatively simple task that I could do for you quite quickly.
$100 USD in 3 days
5.0 (2 reviews)
3.5
3.5
User Avatar
With more than 6 years of experience of working with Oracle plsql development, I would be able to complete this project with maximum efficiency and accuracy. Looking forward to working with you.
$200 USD in 2 days
5.0 (8 reviews)
3.3
3.3
User Avatar
As an oracle database administrator have all system table information and have scripts to enlist all the requested information . Have also knowledge on backup and recovery, Performance tuning, migration, upgradation etc.
$55 USD in 1 day
4.7 (4 reviews)
3.3
3.3
User Avatar
I have more than 15 years experience of Delphi Developer. I started with Delphi 5 and working with XE10.2 Tokyo now. I have experience in Windows API, Network API, COM-Port, DataSnap, Client/Server, parsing big files, develop Multi-threaded application without any memory/resource leaks. Oracle Database (from 8i to 12c), SQL, T-SQL, MySQL, MSSQL. Also I have some experience in C++ and C# programming languages.
$30 USD in 3 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Hi You can refer my profile and if interested please ping me. I would like to know the Linux distribution on which the Oracle db is running. Happy to discuss further. Thank you.
$133 USD in 2 days
5.0 (1 review)
1.1
1.1
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database
$155 USD in 3 days
0.0 (1 review)
2.1
2.1
User Avatar
Hi, I am full stack software developer and worked with all big databases like sql my sql mongo db and also been working with oracle for past 4 years. Can get this done for you. We can discuss this further if you need to. Regards, Zee
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Looking for my first project on freelancer. I am an experienced DBA for both administration and development. I have a few questions about the reports though. #1. What edition are you using (standard,enterprise) and is auditing turned on? #2. How do you intend to to have the reports presented? Via emailed results? Access via sqlplus? Thanks, Adam
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am Mahesh, Having experience of 4.10 years in database development and I have worked on 3 Huge projects. --> Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines --> We are a team of 3 people to work together and make project success in given time.
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working as a DB Developer in IT company so this is my regular work I can do this more efficiently.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 12 years experience as Oracle DBA. I have real time experience in Oracle database along with shell scripting. Relevant Skills and Experience Real time experience in Oracle Database Administration and Shell Scripting.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am good at these kind of scripts creation. Currently i work on Oracle databases & develop DB to many applications. Let us give a try for 3 days I will finish it off which you have expected.
$165 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Sir I'm An Oracle DBa of 10 Yrs of experience I can provide support for your task and deploy required script
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 12 yrs experience in oracle related job ,if you want give me try.I can easily complete this task.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, My name is Bipin Sahani and I am a Oracle Database Administrator and Architect with about 17 years of experience. I have extensive experience in Oracle users, roles and priveleges. I am also an Oracle Certified DBA (OCP DBA). In my recent project in Toyota Motors Pvt. Ltd., I developed these similar scripts for SOX audit purpose. Please let me know and I can send you the scripts. Thanks, Bipin Sahani
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have similar script(s) ready. Might require some modifications upon reviewing your application structure, but can be covered in one day.
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PERU
Peru
0.0
0
Member since May 29, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.