#DateForumTypeThreadPost
730 Sep 2009 @ 04:56 PDTDatabaseReplyExtracting Object PermissionsThanks for the information. So what your saying is the easiest way to create a script of object permissions would be to create a dynamic query such as:Substituing the dbc.allrolerights.accessright ...
630 Sep 2009 @ 01:54 PDTDatabaseTopicExtracting Object PermissionsHello,Is there a way to find and extract the permissions of objects using bteq?I want to create an output file that scripts out the permissions for a specific object (table, stproc, macro etc...)ex...
526 Dec 2008 @ 09:53 PSTToolsTopicDuplicate storage objects foundHello,We have divided several of our backups into three tape groups on our BAR server which back up to a SAN. Groups 2 and 3 are working properly, however the 1st tape fails with error below. Our b...
419 Sep 2008 @ 04:52 PDTDatabaseReplyLinking a Table name to a table IdI was guessing you would say that was the next option.Thanks again for your helpful replies....I'll go with converting the values then.cheers-rrenn001
319 Sep 2008 @ 09:19 PDTDatabaseReplyLinking a Table name to a table IdDieter,Thank you for your help, that would have seemed to do the trick, however its not actually producing results in hex format, it still outputs in decimal.cmd -> radix input in decimaloutput ...
218 Sep 2008 @ 05:10 PDTDatabaseReplyLinking a Table name to a table IdThe reason I am asking is because in ferret, the tableid's are in decimal. I am not trying to do conversions to get the tables/ids matched up from hex to decimal. select tablename, tableid from dbc...
118 Sep 2008 @ 04:22 PDTDatabaseTopicLinking a Table name to a table IdHello,Are there any system tables, views that will correlate tables name to its table id?I have tried looking in dbc.tables,dbc.columns with no luck. Thanks for your help.