Ïðî÷èòàòü äàííûå MSysRelationships
|
|
Ñðåäà, 25 Ôåâðàëÿ 2015 ã. 15:00
+ â öèòàòíèê
Íå ïîëó÷àåòñÿ ïðî÷èòàòü ÷åðåç ADO èç òàáëèöû MSysRelationships - íåò ïðàâ.
Ïûòàëñÿ ðàçíûìè ñïîñîáàìè äîáàâèòü ïðàâà, íî âîçíèêþò ðàçëè÷íûå îøèáêè.
Ê ïðèìåðó, ÷åðåç ADOX:
DB := CoCatalog.Create;
DB.Set_ActiveConnection(FormatConnectionString(DBName) + ';Persist Security Info=False;');
try
DB.Users['Admin'].SetPermissions('MSysRelationships', adPermObjTable,
adAccessSet, adRightRead, adInheritNone, EmptyParam);
finally
DB := nil;
end;
Èëè ÷åðåç ADO: con.Execute('GRANT SELECT ON MSysRelationships TO Admin;') òîæå âîçíèêàåò îøèáêà.
Äëÿ ÷åãî ýòî íàäî? Äëÿ òîãî, ÷òîáû îïðåäåëèòü, êàêèå èíäåêñû ó òàáëèö ÿâëÿþòñÿ ñèñòåìíûìè (àâòîìàòè÷åñêè ñãåíåðèðîâàííûìè), ÷òîáû èõ íå òðîãàòü ïðè ïåðåíîñå ñòðóêòóðû áàçû. ×åðåç ADOX òàêèå èíäåêñû íå îòëè÷àþòñÿ îò îáû÷íûõ èíäåêñîâ, íî â ñïèñêå èíäåêñîâ ó òàáëèöû Access èõ íå ïîêàçûâàåò.
Åñòü ëè ó êîãî êàêèå èäåè, êàê åù¸ ìîæíî ïîëó÷èòü äîñòóï ê MSysRelationships?
http://www.sql.ru/forum/1144371/prochitat-dannye-msysrelationships
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-