Sunday, January 16, 2011

How to check if given object is a database or user ?

How to check if given object is a database  or user ?
Answer

To check whether the given object is user or database , we can use following query
sel * from dbc.databases where dbkind  ='U'  or dbkind='D';

3 comments:

  1. This is actually not correct. You would:

    SELECT DBKind
    FROM dbc.databases
    WHERE DatabaseName = 'YOUR_OBJECT_NAME_HERE'

    The query originally provided would give you a full dump of all databases.

    ReplyDelete
  2. Each change that Agent makes on their Call Manager represents a database change. Logging into the system, and Logging out of the system are database changes. How about, accepting a call being offered to the Agent by a Workgroup?mysql dashboards

    ReplyDelete

  3. IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Projects for CSE It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai


    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete