dcsimg
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
    Posts
    17

    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
    Posts
    649

    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.

    Code:
    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
    Location
    Near Nashville TN
    Posts
    5,835

    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: 78
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,
    Elroy
    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
    Posts
    17

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

    thanks

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
  •  



Featured


Click Here to Expand Forum to Full Width