08-12-2013
Ask your DBA what account the
database runs as. If you are the DBA, ask the OS SysAdmin. If you are both, then ........
You will need to know who runs the database, not the user running the SQL with the "write to directory" code in it.
Robin
This User Gave Thanks to rbatte1 For This Post:
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)