P
Paul Koufalis
Guest
The command line should be something like this: DB=sports PORT=sqlsports # as defined in /etc/services URL="jdbc:datadirect
penedge://localhost:-1;databaseName=$DB" URL="${URL};servicename=$PORT;User=Paul;Password=TheWiz!" URL="${URL};defaultSchema=pub" sqlexp -driverUrl "$URL" -infile $SCRIPTDIR/update_grants.$DB.sql -sqlverbose update_grants_sports.sql should look like this: GRANT SELECT ON PUB."customer" TO bob; GRANT SELECT ON PUB."customer" TO jane; GRANT SELECT ON PUB."customer" TO mike; COMMIT;
Continue reading...
penedge://localhost:-1;databaseName=$DB" URL="${URL};servicename=$PORT;User=Paul;Password=TheWiz!" URL="${URL};defaultSchema=pub" sqlexp -driverUrl "$URL" -infile $SCRIPTDIR/update_grants.$DB.sql -sqlverbose update_grants_sports.sql should look like this: GRANT SELECT ON PUB."customer" TO bob; GRANT SELECT ON PUB."customer" TO jane; GRANT SELECT ON PUB."customer" TO mike; COMMIT;Continue reading...