10-14-2001
sqlplus priveleges.
I was wondering if users can be restricted from invoking sqlplus in unix from certain directories. In other words certain users should be able to invoke sqlplus only through certain directories
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
On my FTP server (Darwin/Mac OS X -- pretty much FreeBSD), I need to apply the following permissions to a directory:
1. A specific owner with full access
2. A specific group with full access
3. A specific group with read-only access
4. No access whatsoever for everyone else
I understand... (5 Replies)
Discussion started by: TyHockett
5 Replies
2. UNIX for Advanced & Expert Users
Hello Everyone,
if we log on to unix server how do we find that what permissions/roles and priveleges are assigned to any particular user.
Here i am not talking about the file permissions.
Thanks (1 Reply)
Discussion started by: hardesh
1 Replies
3. UNIX for Dummies Questions & Answers
Hope I'm in the right place to ask this.
... and I'm a total noob by the way.
When changing an account password through telnet, everything seems fine. I can telnet back in afterward, but if I try to use sqlplus to get in it tells me password invalid. If I try to get in through sqlplus with the... (1 Reply)
Discussion started by: tazman4
1 Replies
4. Shell Programming and Scripting
Can someone tell me how to execute sqlplus command.
I`m Executing:
sqlplus user/pasw @/report/output/new/PlatformOut_Cdrs.sql
the error is:
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Aug 9 15:37:44 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:... (3 Replies)
Discussion started by: Nel
3 Replies
5. Shell Programming and Scripting
Hi all,
I am new to SQLPLUS, can anyone tell me what is the following codes doing?
DECLARE
cursor c1 is select bts_int_id,
max(ave_busy_tch/res_av_denom14) maxBusyTch
from p_nbsc_res_avail
where to_char(period_start_time,'yyyymmdd')=to_char((sysdate-1),'yyyymmdd')
group by... (4 Replies)
Discussion started by: antkiu
4 Replies
6. Shell Programming and Scripting
I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is... (9 Replies)
Discussion started by: LiquidChild
9 Replies
7. Shell Programming and Scripting
I am trying to connect to one of the oracle sever using uni through sqlplus
command: sqlplus -s BOXI_ALPH_AUDITOR,Q078_audit$@Q047
But its not getting connected. I tried using some different server using same syntax its working. What differene i found is the password is having no special... (2 Replies)
Discussion started by: gander_ss
2 Replies
8. Shell Programming and Scripting
When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please. the script is a s follows
count=`sqlplus -s $ORACLE_ACCOUNT << EOF
set heading off
set wrap on
set feedback off
column ChangeNumber format a12
column... (9 Replies)
Discussion started by: jhon1257
9 Replies
9. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
10. UNIX and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT BSD
mbk_cata_lib
MBK_CATA_LIB(1) MBK ENVIRONMENT VARIABLES MBK_CATA_LIB(1)
NAME
MBK_CATA_LIB - define the mbk catalog directory
SYNOPSYS
c-shell running
setenv MBK_CATA_LIB path1:path2:path3:...:...:pathn
ORIGIN
This software belongs to the ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in
Paris, France.
Web : http://asim.lip6.fr/recherche/alliance/
E-mail : alliance-users@asim.lip6.fr
DESCRIPTION
MBK_CATA_LIB sets the directories that are to be searched thru for reading. When instanciating a cell for example, the first cell that is
found with the given name is loaded in memory.
The seaching mecanism first look in MBK_WORK_LIB(1), and then, in path1 thru pathn, in the order defined by the user when typing the setenv
command. This directories are considered to be, from a mbk point of view, read only.
The pathi arguments must be actually accessible pathes on your host machine.
ERRORS
"mbk_fopen : can't open file 'unix_path/file.xx' thru directories : path1, ..., pathn"
This occurs when either the unix path is irrelevent, or when the file doesn't exist. This can also be a unix right problem if the
file is not accessible for reading, but this is seldom.
EXAMPLE
setenv MBK_CATA_LIB ~fred/crechan/uom:/labo/sclib
DIAGNOSTICS
Only the first path may be given with a '~', since the shell extents it only when seen first.
SEE ALSO
mbk(3), genlib(1), MBK_WORK_LIB(1).
BUG REPORT
This tool is under development at the ASIM department of the LIP6 laboratory.
We need your feedback to improve documentation and tools.
ASIM
/LIP6 October 1, 1997 MBK_CATA_LIB(1)