Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?
View Answer
| Jun 9 2008 3:10 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SYSTEM TABLESPACE, Meta data
Query SYSTEM tablespace Privileges
I am trying to figure out what privileges two users have to the SYSTEM tablespace... However quering the "user_sys_pivs" table will only give me the privs of the user I am logged onto the system with. Is there anyway I can find out that information without logging to their account. I am using orcl...
View Answer
| Oct 29 2007 9:15 AM GMT
| asked by
Ragheed
SYSTEM TABLESPACE, Oracle
