Results 1 to 4 of 4

Thread: Can't find my table in the data repot

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 2018

    Can't find my table in the data repot

    Hello friends
    I have a problem with visual basic 6.When I look for my table name in object name I can not find it (see this https://ufile.io/5c4wb )
    I'm sure I've create tables in the User System in Oracle database.
    can you help me....

  2. #2
    Fanatic Member
    Join Date
    Jan 2013

    Re: Can't find my table in the data repot

    Why are you creating tables under the SYSTEM account?

    This is a built-in Oracle account that manages all sorts of stuff internal to the database.
    Mess with it at your peril.

    Create your own schema to hold your own tables.

    Then create Role[s] to manage privileges on the tables (and other things) that you create within that schema.

    create user app_schema_1 identified by 'nice_strong_password' ; 
    create table app_schema_1.table1 
    ( dat date ) ; 
    create role app_schema_1_app_role ; 
    grant select, insert, update, delete on app_schema_1.table1 to app_schema_1_app_role ; 
    create role app_schema_1_dev_role ; 
    grant select on app_schema_1.table1 to app_schema_1_dev_role ;
    Regards, Phill W.

  3. #3
    PowerPoster Elroy's Avatar
    Join Date
    Jun 2014
    Near Nashville TN

    Re: Can't find my table in the data repot

    Say monzerahmed6.

    There's an easy to use "insert picture" on these posts. It's the following button on your post toolbar:

    Name:  image.png
Views: 86
Size:  9.8 KB

    The way you've done it, I click your link and it takes me through all kinds of "slow download or please sign up" options, and I think to myself "nope, not gonna do any of this."

    Take Care,
    Any software I post in these forums written by me is provided “AS IS” without warranty of any kind, expressed or implied, and permission is hereby granted, free of charge and without restriction, to any person obtaining a copy. Please understand that I’ve been programming since the mid-1970s and still have some of that code. My contemporary VB6 project is approaching 1,000 modules. In addition, I have a “VB6 random code folder” that is overflowing. I’ve been at this long enough to truly not know with absolute certainty from whence every single line of my code has come, with much of it coming from programmers under my employ who signed intellectual property transfers. I have not deliberately attempted to remove any licenses and/or attributions from any software. If someone finds that I have inadvertently done so, I sincerely apologize, and, upon notice and reasonable proof, will re-attach those licenses and/or attributions. To all, peace and happiness.

  4. #4

    Thread Starter
    Junior Member
    Join Date
    Jan 2018

    Re: Can't find my table in the data repot


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts


Click Here to Expand Forum to Full Width