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....
Printable View
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....
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.
Regards, Phill W.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 ;
Say monzerahmed6.
There's an easy to use "insert picture" on these posts. It's the following button on your post toolbar:
Attachment 156321
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
thanks