• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can't find the special schema.

 
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: 9067
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, Tommy Lee.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
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