06-02-2008
Even with the bigger script , the result is bit closer to what we want but still the table name is not omitted from adding VW_ to it ( DIM_PROVIDER is the table name in this sql file ) .
Here is grep on GRANT after I ran the full script .
#grep -i grant OPSDM002.dim_provider.20080602.sql
GRANT SELECT ON TABLE OPSDM002.VW_.DIM_PROVIDER TO GROUP DSDBDEV ;
GRANT SELECT ON TABLE OPSDM002.VW_.DIM_PROVIDER TO GROUP UHCDMTST ;
GRANT SELECT ON TABLE OPSDM002.VW_.DIM_PROVIDER TO GROUP CLOSEL01 ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_MBR_PRI TO GROUP DSDBDEV ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_MBR_PRI TO GROUP UHCDMTST ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_MBR_PRI TO GROUP CLOSEL01 ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_REF TO GROUP DSDBDEV ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_REF TO GROUP UHCDMTST ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_REF TO GROUP CLOSEL01 ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_SRVC TO GROUP DSDBDEV ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_SRVC TO GROUP UHCDMTST ;
GRANT SELECT ON TABLE OPSDM002.VW_.PROVIDER_SRVC TO GROUP CLOSEL01 ;
The code part is
awk -v tn="$TN" -v ts="$target_schema" '/^GRANT/ && !/tn/{sub(ts,ts".VW_")}1' ${target_schema}.$TN.${ecmdate}.sql > $tmpfile_cln
Thanks ,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
There is a requirement that i need to replaced a pattern by another pattern in all the files in my entire file system. there are 1000s of file in the system. let the pattern is "calcuta". i have to replace this pattern by "kolkata" in all those files which contain "calcuta".
I am only able to... (12 Replies)
Discussion started by: palash2k
12 Replies
2. Shell Programming and Scripting
Hi,
I have file 1.txt with following entries as shown:
0152364|134444|10.20.30.40|015236433
0233654|122555|10.20.30.50|023365433
**
**
**
In file 2.txt I have the following entries as shown:
0152364|134444|10.20.30.40|015236433
0233654|122555|10.20.30.50|023365433... (4 Replies)
Discussion started by: imas
4 Replies
3. Shell Programming and Scripting
Hi all,
I'm looking for some help. I have a file (very long) that is organized like below:
>Cluster 0
0 283nt, >01_FRYJ6ZM12HMXZS... at +/99%
1 279nt, >01_FRYJ6ZM12HN12A... at +/99%
2 281nt, >01_FRYJ6ZM12HM4TS... at +/99%
3 283nt, >01_FRYJ6ZM12HM946... at +/99%
4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies
4. UNIX for Dummies Questions & Answers
Hi I'm a newbie in unix and I'm having trouble in creating a script. I want to search for a pattern '_good' and insert new lines that contains '_bad', '_med', '_fail' while also ensure that the line contains _good is removed
here some of the data
UPDATE SCHOOL SET GRADE =... (1 Reply)
Discussion started by: sexyTrojan
1 Replies
5. Shell Programming and Scripting
Hi
I am having a code snippet
grant permission to all user
sts|ln|uSe|PSG
sajncht|se|Use|PPSPSG
psg|ln|use|TSPSG
sts_user.Me revoke
I need to change all occurance of use (uSe,Use,use) with USE. I am using the following sed command for this
sed 's//USE/g' s_sample.txt
Output: (7 Replies)
Discussion started by: sudeep.id
7 Replies
6. Shell Programming and Scripting
'Hi
I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match.
Which option is to be used to exclude the line containing the pattern?
sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies
7. Shell Programming and Scripting
The sample file:
dept1: user1,user2,user3
dept2: user4,user5,user6
dept3: user7,user8,user9
I want to match by '/^dept2.*/' but don't want to have substring 'dept2:' in output. How to compose such regex? (8 Replies)
Discussion started by: urello
8 Replies
8. Shell Programming and Scripting
Hello Everybody,
I need a help in the below pattern matching and replacement issue
I have a file : emp.txt
21356 suresh 12/12/2012
23511 ramesh 11/06/2011
31456 biswajit 09/08/2013
53134 archan 06/02/2009
first field:- employee id, 2nd field is name and third field is date of joining
... (10 Replies)
Discussion started by: shellscripting
10 Replies
9. Shell Programming and Scripting
Hi Techies,
I need a help in finding junk characters and remove them from a Datafile.
we have a file and it had crores of records like below
SGSN_MCC_MNC=01150
but sometime due to the issue with sending server we are getting some junk characters in the middle of data like below
... (6 Replies)
Discussion started by: mahi_mayu069
6 Replies
10. UNIX for Dummies Questions & Answers
Hi all!
Thanks for taking the time to view this!
I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern.
Example:
Drink a soda
Eat a banana
Eat multiple bananas
Drink an apple juice
Eat an apple
Eat multiple apples
I... (8 Replies)
Discussion started by: demmel
8 Replies
LEARN ABOUT CENTOS
alter_default_privileges
ALTER DEFAULT
PRIVILEGES(7) PostgreSQL 9.2.7 Documentation ALTER DEFAULT PRIVILEGES(7)
NAME
ALTER_DEFAULT_PRIVILEGES - define default access privileges
SYNOPSIS
ALTER DEFAULT PRIVILEGES
[ FOR { ROLE | USER } target_role [, ...] ]
[ IN SCHEMA schema_name [, ...] ]
abbreviated_grant_or_revoke
where abbreviated_grant_or_revoke is one of:
GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[, ...] | ALL [ PRIVILEGES ] }
ON TABLES
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { USAGE | SELECT | UPDATE }
[, ...] | ALL [ PRIVILEGES ] }
ON SEQUENCES
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTIONS
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON TYPES
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[, ...] | ALL [ PRIVILEGES ] }
ON TABLES
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { USAGE | SELECT | UPDATE }
[, ...] | ALL [ PRIVILEGES ] }
ON SEQUENCES
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTIONS
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON TYPES
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
DESCRIPTION
ALTER DEFAULT PRIVILEGES allows you to set the privileges that will be applied to objects created in the future. (It does not affect
privileges assigned to already-existing objects.) Currently, only the privileges for tables (including views and foreign tables),
sequences, functions, and types (including domains) can be altered.
You can change default privileges only for objects that will be created by yourself or by roles that you are a member of. The privileges
can be set globally (i.e., for all objects created in the current database), or just for objects created in specified schemas. Default
privileges that are specified per-schema are added to whatever the global default privileges are for the particular object type.
As explained under GRANT(7), the default privileges for any object type normally grant all grantable permissions to the object owner, and
may grant some privileges to PUBLIC as well. However, this behavior can be changed by altering the global default privileges with ALTER
DEFAULT PRIVILEGES.
Parameters
target_role
The name of an existing role of which the current role is a member. If FOR ROLE is omitted, the current role is assumed.
schema_name
The name of an existing schema. If specified, the default privileges are altered for objects later created in that schema. If IN SCHEMA
is omitted, the global default privileges are altered.
role_name
The name of an existing role to grant or revoke privileges for. This parameter, and all the other parameters in
abbreviated_grant_or_revoke, act as described under GRANT(7) or REVOKE(7), except that one is setting permissions for a whole class of
objects rather than specific named objects.
NOTES
Use psql(1)'s ddp command to obtain information about existing assignments of default privileges. The meaning of the privilege values is
the same as explained for dp under GRANT(7).
If you wish to drop a role for which the default privileges have been altered, it is necessary to reverse the changes in its default
privileges or use DROP OWNED BY to get rid of the default privileges entry for the role.
EXAMPLES
Grant SELECT privilege to everyone for all tables (and views) you subsequently create in schema myschema, and allow role webuser to INSERT
into them too:
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT INSERT ON TABLES TO webuser;
Undo the above, so that subsequently-created tables won't have any more permissions than normal:
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema REVOKE SELECT ON TABLES FROM PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema REVOKE INSERT ON TABLES FROM webuser;
Remove the public EXECUTE permission that is normally granted on functions, for all functions subsequently created by role admin:
ALTER DEFAULT PRIVILEGES FOR ROLE admin REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;
COMPATIBILITY
There is no ALTER DEFAULT PRIVILEGES statement in the SQL standard.
SEE ALSO
GRANT(7), REVOKE(7)
PostgreSQL 9.2.7 2014-02-17 ALTER DEFAULT PRIVILEGES(7)