Archives of the TeradataForum
Message Posted: Mon, 24 Jun 2002 @ 20:56:48 GMT
| Subj: || || Re: Archive accessrights |
| From: || || Joanne Schultz |
If you look at the dbc.accessrights table, you'll see that it keeps track of everything by internal id. If you do a grant at a database
level that information is kept by database id. If you do a grant at the table level that information is kept by table id.
If you have the same database ids as before, then the accessrights that were granted on databases are still valid. But if you create new
tables by using "copy" instead of "restore", then you lose grants that were done on those specific tables.