• Post Reply Bookmark Topic Watch Topic
  • New Topic

Can't find the special schema.  RSS feed

 
Tommy Lee
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have two schema that are scA and scB.
I get getTablePrivileges("","scA","%")
but Can't get getTablePrivileges("","scB","%").
why I can't get scB TablePrivileges?
ps :
when I use getPrimaryKey("","scB","ALL_ACTIVITY"),
I can got the primaryKey.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Tommy_Lee",
Please change your display name, accounts with illegal display names get deleted
We're light on rules at the 'Ranch, but we do enforce the naming policy. You can edit your profile here.
You must have your first name, a space, then your last name, and obviously fictitious names are not allowed.
Thanks.
Dave
 
Marilyn de Queiroz
Sheriff
Posts: 9081
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, Tommy Lee.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 37395
531
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tommy,
Do you have read access to the schema/table. If not, the commands should not work.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!