Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Exclamation Unanswered: SQL PLUS Commands

    I'm new to oracle, can anyone help me in tellling the commands to set the schema or change the schema related topic information. i've tried this command
    set schema myschema;

    it didnt workout throws the error message

    help me soon

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    you connect as <user>/<pwd>@sid

    the <user> is tightly connected to a schema

    you can retrieve your objects

    select * from user_objects

  3. #3
    Join Date
    Jan 2004
    Posts
    3

    Re: SQL PLUS Commands

    Originally posted by anandbabu
    I'm new to oracle, can anyone help me in tellling the commands to set the schema or change the schema related topic information. i've tried this command
    set schema myschema;

    it didnt workout throws the error message

    help me soon
    hi its me again

    can anyone also help me ingranting the permissions in Oracle, whn i login as system and manager i'm able to see the tables and view of my schema,
    whn i login as normal user i couldn't can anyone helpme on this too.

    thnks in advance
    Anand

  4. #4
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Example,

    User: System

    create table t1 (
    id number(1)
    );

    Create user test_user identified by password

    grant create session to test_user;

    grant select on t1 To test_user;

    User: test_user

    Select * from system.t1;
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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