Kbase P108928: What files need to be dump and loaded to retain the SQL 92 users names and table permissions?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2009 |
|
Status: Unverified
GOAL:
What files need to be dump and loaded to retain the SQL92 users names and table permissions?
GOAL:
What files need to be dump and loaded to retain the SQL92 users names and passwords?
GOAL:
What files need to be dump and loaded to retain the SQL92 permissions granted to users?
GOAL:
What files need to be dump and loaded to retain the SQL92 rights granted to users?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
When dump and loading a database that has SQL 92 security enabled you should include the table which contain the user names/password, the definition of DBA users, and the table which contains the rights granted to a user.
The table which contains the user names/passwords is the _user.
The table which contains the definition of what users have DBA rights is the sysprogress.sysdbauth.
The table containing the user rights is called sysprogress.systabauth.
Be sure to include these 3 tables in your dump and load process if you wish to pass the same security settings to the new database.
The sysprogress.sysdbauth and sysprogress.systabauth should be dumped using the sqldump utility.
Syntax for sqldump
sqldump -u username -a password -t table-list database-url [options]
Valid options:
database-url Identifies the database to which you want to connect.
progress:T:<host_name>:<service_name>:<database_name>
-a password User authentication
-f command-filename Specifies the file where SQLDUMP reads
commands on how and what to dump.
Mutually exclusive with (-t) table.
-n error-check Check for syntax errors without dumping any rows.
-t table[,table...] List of tables to dump separated by commas.
('%' for all tables)
Mutually exclusive with (-f) command-filename.
-u username User authentication
-C charset The name of the character set of the
tables to be dumped.
-F { comma | quote } comma: dump in comma-delimited format
quote: dump in quote-delimited format
[default = quote]