Raymond O'Donnell wrote:
On 22/05/2008 22:33, smiley2211 wrote:
1) dump database A - 2) Extract permissions from database B - (HOW)
How about dumping B using the plain-text format, then running the output
through grep, looking for lines starting with "GRANT..."?
Hint: sometimes easier
On 22/05/2008 22:33, smiley2211 wrote:
1) dump database A -
2) Extract permissions from database B - (HOW)
How about dumping B using the plain-text format, then running the output
through grep, looking for lines starting with "GRANT..."?
Ray.
--
Hello all,
How do I capture the EXISTING permissions for a database? I know you can
see them via \z or \dp however I need ALL permissions to be captured so I
can reapply after performing a database restore.
ex:
1) dump database A -
2) Extract permissions from database B - (HOW)
3) load d
