08-12-2013
Quote:
Originally Posted by
rbatte1
The account running the database (sounds like oracle for you) needs unix permissions to write to the unix directory in question. Within the database your account (seems like usr_1) would need to have the oracle system privilege CREATE ANY DIRECTORY
Of course, you have to consider that you are then taking datab out of the database and writing it in a plain file. Does this breach your security rules? Who else will be able to see the data? is there anything client on company confidential in it (e.g. bank accounts, contact details, medical stuff, corporate statements or financial investments etc.)
This latter point is not for me to draw a conclusion about because I don't know what business you are in, but we all have to consider the risks of exposing data, even to people we trust.
Robin
Liverpool/Blackburn
UK
Thanks.
10 More Discussions You Might Find Interesting
1. Solaris
I am using oracle 9i with sun solaris 8 on Sun E 250 server.earlier we are taking backup of oracle archive files on /orabackup directory.in which archive file are stored with ...arc.Z extension. now we have changed the archive backup directory.now when we are trying to delete earlier directory... (3 Replies)
Discussion started by: mahanalok
3 Replies
2. Shell Programming and Scripting
Hi,
I have a file abcd.txt which has contents in the form of full path file names i.e.
$home> vi abcd.txt
/a/b/c/r1.txt
/q/w/e/r2.txt
/z/x/c/r3.txt
Now I want to retrieve only the directory path name for each row
i.e
/a/b/c/
/q/w/e/
How to get the same through shell script?... (7 Replies)
Discussion started by: royzlife
7 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I am trying to run a shell script which contains an mkdir command as part of the execution. The script fails with the following error:
mkdir: cannot create directory `/builds/somedir/': Permission denied
The user running the script is 'harry' and belongs to group 'school'.... (5 Replies)
Discussion started by: Technext
5 Replies
4. UNIX and Linux Applications
Hi all,
I have a problem when I try to create a Directory Server on Directory Service Control Center - DSCC.
The log shows the following:
Creating Directory Server test1:389. Server Logs:
couldn't set locale correctly
couldn't set locale correctly
Directory '/var/ds/' already exists... (1 Reply)
Discussion started by: Yohanna Flores
1 Replies
5. Red Hat
for incompatibility installation problems, I've decided to reinstall Centos 6.3
as can be seem from the df output, I've partitioned both / and and /home directories
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda8 12G 5.3G 6.5G 45% /
tmpfs ... (2 Replies)
Discussion started by: jediwannabe
2 Replies
6. Shell Programming and Scripting
i need to give permission to ORACLE SERVER to create a directory in a particular path.
How to do it?Oracle server is installed in Unix (11 Replies)
Discussion started by: rafa_fed2
11 Replies
7. AIX
Hi.
My example:
I have a filesystem /log. Everyday, log files are copied to /log. I'd like to set owner and permission for files and directories in /log like that
chown -R log_adm /log/*
chmod -R 544 /log/*It's OK, but just at that time. When a new log file or new directory is created in /log,... (8 Replies)
Discussion started by: bobochacha29
8 Replies
8. Solaris
Hi All,
I have this file system /sys/app/ and application creating many file under that path.
I want any created file under that path to be created with 644 permission
Any help support in this please! (2 Replies)
Discussion started by: AbuAliiiiiiiiii
2 Replies
9. UNIX for Beginners Questions & Answers
Hello,
I am creating a file with all the source folders included in my git branch, when i grep for the used source, i found source included as relative path instead of absolute path, how can convert relative path to absolute path without changing directory to that folder and using readlink -f ? ... (4 Replies)
Discussion started by: Sekhar419
4 Replies
10. UNIX for Beginners Questions & Answers
What is the difference ../directory path and ./directory path in ksh? (1 Reply)
Discussion started by: TestKing
1 Replies
LEARN ABOUT REDHAT
drop_user
DROP
USER(7) SQL Commands DROP USER(7)
NAME
DROP USER - remove a database user account
SYNOPSIS
DROP USER name
DESCRIPTION
DROP USER removes the specified user from the database. It does not remove tables, views, or other objects owned by the user. If the user
owns any database, an error is raised.
PARAMETERS
name The name of an existing user.
DIAGNOSTICS
DROP USER
The message returned if the user is successfully deleted.
ERROR: DROP USER: user "name" does not exist
This message occurs if the user name is not found.
DROP USER: user "name" owns database "name", cannot be removed
You must drop the database first or change its ownership.
NOTES
Use CREATE USER [create_user(7)] to add new users, and ALTER USER [alter_user(7)] to change a user's attributes. PostgreSQL includes a
program dropuser [dropuser(1)] that has the same functionality as this command (in fact, it calls this command) but can be run from the
command shell.
EXAMPLES
To drop a user account:
DROP USER jonathan;
COMPATIBILITY
The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.
SEE ALSO
CREATE USER [create_user(7)], ALTER USER [alter_user(l)], dropuser(1)
SQL - Language Statements 2002-11-22 DROP USER(7)