Post reply

a very wierd one...mite put ur experience to real test

  • October 9, 2005 at 11:54 pm

    #166307

    Hi  ,

    I am amid resolving a wierd issue.

    The database i am trying to query would let me query all the tables present in the database.there are almost a 1000 of them.I can query them and i get the records.

    But the execution of the stored procedure  "sp_tables"  would return only one table.I was puzzled by this.

    can someone clarify this inconsistency.

    thank you

    a very wierd one...mite put ur experience to real test

  • October 10, 2005 at 3:10 am

    #596229

    Hi!!!!

    this SP Execute permission default to public role.

    Examples
    A. Return a list of objects that can be queried in the current environment
    EXEC sp_tables
    so first check that u r not assinged to any specific roll and 
    if yes then the table u created in that roll is only display!!
     
    Rest is urs!!!

    Regards,

    Papillon

  • October 10, 2005 at 11:33 am

    #596340

    can u please elaborate on this.

    for ur information i just have query access on this database;and these tables were not created by me.

    i just joined a new job here

  • October 10, 2005 at 10:14 pm

    #596432

    Hi!!!

    As u told that u r new joiny there , so might be possible that u have given access to only that table , that u r seeing by this SP...

    cause normally when we qyeried this SP , by defalut all the tables (Systems or user defined) must be seen.....so first u check that...can u able to fire a query on other tables also....i.e select statement on other tables also.....if u cannot then u r not able to see other tables by this SP....though u r seeing other tables in EM........

    Have a nice day!!!!

    Regards,

    Papillon

  • October 11, 2005 at 1:34 pm

    #596644

    hi shashank,

    i am able to fire select on all the tables!!!

     

    thanks for ur time

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply