How to set restricted user by rksh? Cannot use Perl module DBD::Oracle


 
Thread Tools Search this Thread
Operating Systems Solaris How to set restricted user by rksh? Cannot use Perl module DBD::Oracle
# 1  
Old 06-22-2007
Question How to set restricted user by rksh? Cannot use Perl module DBD::Oracle

Hi, all,

I need to add a user to our system in order to let him use Oracle and Perl. We want him to remain in his home directory and have no access to our data and other users' files.

I created a separate group for this user, and set his shell to rksh when I created his account, by which he can not redirect to other places. But when I log in with his account to test, I found I still can browse to other places via File Manager GUI. I then set the ACLs list to restrict his access to other users folders under /export/home, as well as our data folders.

The next I found the PATH of this accout was not set correctly because it could not find Perl, so I set the PATH in .dtprofile, .profile, .kshrc to make Perl available to this account. Now I found it could not use Perl module DBD::Oracle, the system gave the following message when I tried to run a perl script:

install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: perl5.8.3: fatal: /u01/oracle/IBMT/product/9.2.0/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected

Another thing I noticed is when I open the terminal and type pwd, it returns a different path from HOME, I've tried to set HOME but doesn't seem to work.

From your experts point of view, what canI do to achieve my goals? (The Oracle account for this user has beed set to only allow him to use his own data.)

TIA.
Alan
# 2  
Old 06-22-2007
Have you looked into a Jail Shell?

This sounds like you want a jail shell. Allowing the user to login and use very pacific programs and nothing else.


checkout:
You might also find some Jail Shells for BSD that could be adapted to Solaris.
# 3  
Old 06-22-2007
Quote:
Originally Posted by harmonwood
This sounds like you want a jail shell. Allowing the user to login and use very pacific programs and nothing else.


checkout:


You might also find some Jail Shells for BSD that could be adapted to Solaris.
Thanks for the quick reply, I'll try it, and see if Perl and Oracle work for this user under this shell.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

set ksh script in restricted mode

Hi, I came across a post wherein you can use "set -r"(on bash) to activate restricted mode ( wherein you cant run some commands such as cd etc). Can anyone guide if we have anything similar in ksh ? Thanks (2 Replies)
Discussion started by: Shivdatta
2 Replies

2. Windows & DOS: Issues & Discussions

Installing MySql DBD in dtrawberry perl

Hi Guys, I am trying to install DBI and DBD-MYSQL for strawberry perl. But i am not able to install. :wall: DBD-MYSQL >> makefile.pl gives error as 'Access denied for user 'ODBC'@'localhost' (using password: NO)'. (7 Replies)
Discussion started by: vasanth.vadalur
7 Replies

3. Solaris

How to set stack for Oracle's user?

Hi all! I've got a problem. Primary: Sun Sparc V890, 64bit Standby: HP-Proliant ML 350, 64bit In the machine that I've got configured physical standby database, the alert_log_file point me one error: Sat Feb 28 00:40:08 2009 ORA-00202: control file:... (5 Replies)
Discussion started by: trantuananh24hg
5 Replies

4. UNIX for Advanced & Expert Users

make test fails for DBD::Oracle installation

I've already installed the DBI Perl Module with no issues and now I'm attempting to install the DBD::Oracle driver on a Red Hat Enterprise 4 server and am having some trouble. I've checked through the forums and haven't seen anything helpful at this point. Everything goes fine during the perl... (1 Reply)
Discussion started by: pstrosnyder
1 Replies

5. Shell Programming and Scripting

Installing Perl DBI and DBD

Hi, i have some queries on installing the Perl DBI and the DBD Oracle. I know that i have to install the DBI first. I have the source files in a folder in my home directory.The commands to install arecd /home/DBI Perl Makefile.PL make make installI would like to know, after executing these... (4 Replies)
Discussion started by: new2ss
4 Replies

6. UNIX and Linux Applications

help: error in installing perl module DBD::mysql

Hi, I am trying to install perl module DBD::mysql and don't know how to resolve the following: # make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00base.............ok 3/5install_driver(mysql) failed: Can't load... (3 Replies)
Discussion started by: Yogesh Sawant
3 Replies

7. Shell Programming and Scripting

perl DBI/DBD Module -in cygwin

Hi all, I am trying to install the DBI module in perl using perl -MCPAN -e shell install 'DBI' --It is installing into the nuild directory properly but when it try to make it is saying NOT OK -I tried to copy the module manually to the /lib/perl5/vendor_perl ... (3 Replies)
Discussion started by: jambesh
3 Replies

8. Shell Programming and Scripting

DBD-Informix drive for windows version of perl

Hi, I want to know where can I download the DBD-Informix drive for windows version of perl. Regards, Mahehs :confused: (0 Replies)
Discussion started by: maheshsri
0 Replies

9. UNIX for Advanced & Expert Users

perl-DBD-Oracle

I am trying to install perl-DBD-Oracle-1.16-1.2.rpm on Suse (SLE 9), like rpm -Uvh perl-DBD-Oracle-1.16-1.2.rpm but I keep getting the following error message error: Failed dependencies: libclntsh.so.10.1 is needed by perl-DBD-Oracle-1.16-1.2.el4 libnnz10.so is needed by... (1 Reply)
Discussion started by: hassan1
1 Replies

10. UNIX for Advanced & Expert Users

perl module DBD-Oracle

I am trying to install Oracle perl module(DBD-Oracle). MY oracle server runs on solaris 8 while the machine am tring to install DBD-Oracle runs Suse linux 9(SLE 9) Oracle client library including sqlplus are NFS mount on my suse linux machine from my solaris oracle server but when I run make on... (1 Reply)
Discussion started by: hassan1
1 Replies
Login or Register to Ask a Question