Re: database privileges
Posted in 1994
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Security, Permissions & Auditing
Keith, Why don't you just put the "grant" "revoke" or whatever statements into an ascii files and execute them from the unix level. For example, create a file with each line being a separate "grant" or whatever statement. 1. grant update on "owner".table1 to "fred" as "owner"; 2. grant select on "owner".table2 to "joan" as "owner"; "owner" of couse being the owner of the table. Call the file "something".sql , like maybe "setaccess.sql" and then run it from the command line... "isql database_name setaccess" By using "vi" or some editor at the command line it is very easy to make global changes quite easily. I hope this helps and is not something that you are already doing. (don't you hate it when that happens?) Christopher Christopher Cale Internet: chrisc@spamis.jcdc.eta.gov Systems Administrator Voice: 1-800-598-5008 Metrica, Inc. 205 6th St. San Marcos, Tx USA 78666-9007 On Thu, 13 Oct 1994, Keith Howard wrote: > Hi netters, > > We have a need to do some individual table privileges in our system > and it's getting very tedious using SQL. So, before I go about > trying to re-invent the wheel, I thought that someone might have > already developed some 4GL code that will GRANT or REVOKE > specified table privileges for individuals. If so, I would be > forever grateful as it would undoubtedly save me much time and > energy (neither of which I have much of :-) > > Keith Howard > Service Systems Enterprises > >