Creating oracle user and giving him grants using shell script Post: 302360742

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

mv command is giving error in shell script

Hi, In my shell script when I am using mv command using shell variables it is giving me error of syntax. Following is the shell script: file_edifice="*.txt" fquote="'" fdquote=\" for file in $file_edifice do file_name=$fquote$file$fquote tofile_name=`date...

2. Shell Programming and Scripting

Help in Shell scripting to modify the User Creation script in oracle database.

Hi, I have several users to create on my test Oracle database taking the scripts from the Production Oracle database. I have a separate text file where I have user-id and passwords maintained. I need help in writing a shell script to go thru the user creation scripts and replace VALUES...

3. Shell Programming and Scripting

giving input to a python wch has been called frm shell script....urgent

i'm calling a python script from shell script. the python needs Y as an input everytime. how can i giv it thru shell script. I tried below code for arg in `cat erd_gen_list.lst` do generateErdSql.py -S $arg << Y done This is giving me err : `<<' unmatched pls help.

4. Shell Programming and Scripting

Help with script to stop a user giving kill command on a server!!

Hi, I am new to shell scripting and want to create a script with the follwoing description: I want to restrict the users from giving a kill command on a unix server. The server have a restricted logins with login id and passwords. I want a script that will find out if a user has given a...

5. Shell Programming and Scripting

Disk Monitoring shell script giving incorrect information

Hi All, OS: Linux 86x64 bits Red Hat Linux I get the email alert for the following when Alert condition is set for 30: /dev/sda1 99M 21M 74M 22% /boot -> Below 30%(Should not get the email alert) Expected output as per E-Mail alert: /dev/sda3 20G ...

6. Shell Programming and Scripting

Giving automatic multiple Input to a tool from shell script

Hi, Please help me,its urgent. I have a tool that i want to run from a shell script. When we run the tool it will ask the user choice to add or delete. When user enter the choice it will then ask how many units he want to delete or add and will add or delete accordingly. Now I want to...

7. Shell Programming and Scripting

shell script is giving different resultControlled Special Account [csdwmast@ucdoud01.am.sony.com

Hi All, In this below script i am not able to find where is "form mail id" is taking when this script is executing i am getting "Controlled Special Account " as from ,i need to send "form mail id " from a table.:mad: kindly help me plzz. Regards, Krupa

8. Shell Programming and Scripting

How the user will provide the parameters for Oracle db connection in a shell script?

I'm new into unix. My question: is possible to write a shell script which will ask for the ORACLE_HOME, ORACLE_SID, USERNAME, PASSWORD to connect to Oracle db. In generally we have to set the ORACLE_HOME in .profile file. And after putting the 'sqlplus' command it asks for the username &...

9. Shell Programming and Scripting

Sql command inside shell script runs without giving anything back as outout

#!/bin/sh # This script returns the number of rows updated from a function echo "The execution is starting ....." sqlplus -silent $UP <<EOF set serveroutput on set echo off set pagesize 0 VAR no_rows_updated NUMBER; EXEC :no_rows_updated :=0; DECLARE CURSOR c_update is SELECT * FROM...

LEARN ABOUT CENTOS

pkg::create

pkg::create(n)						       Tcl Built-In Commands						    pkg::create(n)

__________________________________________________________________________________________________________________________________________________

NAME

       pkg::create - Construct an appropriate 'package ifneeded' command for a given package specification

SYNOPSIS

       ::pkg::create -name packageName -version packageVersion ?-load filespec? ... ?-source filespec? ...
_________________________________________________________________

DESCRIPTION

       ::pkg::create  is  a utility procedure that is part of the standard Tcl library.  It is used to create an appropriate package ifneeded com-
       mand for a given package specification.	It can be used to construct a pkgIndex.tcl file for use with the package mechanism.

OPTIONS

       The parameters supported are:

       -name packageName
	      This parameter specifies the name of the package.  It is required.

       -version packageVersion
	      This parameter specifies the version of the package.  It is required.

       -load filespec
	      This parameter specifies a binary library that must be loaded with the load command.  filespec is a list	with  two  elements.   The
	      first  element  is  the name of the file to load.  The second, optional element is a list of commands supplied by loading that file.
	      If the list of procedures is empty or omitted, ::pkg::create will set up the library for direct loading (see pkg_mkIndex).  Any num-
	      ber of -load parameters may be specified.

       -source filespec
	      This  parameter  is  similar to the -load parameter, except that it specifies a Tcl library that must be loaded with the source com-
	      mand.  Any number of -source parameters may be specified.

       At least one -load or -source parameter must be given.

SEE ALSO

       package(n)

KEYWORDS

       auto-load, index, package, version

Tcl									8.3							    pkg::create(n)