Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Simple SQL question

  • 10-04-2006 3:15pm
    #1
    hannable80
    Registered Users, Registered Users 2 Posts: 272 ✭✭


    when i log in to my sql in college i seem to be put in a created database called scott, i need to get out of this as every time i try to create a table , i get an error......Example of the data base
    DESC SCOTT.BONUS;
    DESC SCOTT.DEPT;
    DESC SCOTT.EMP;
    DESC SCOTT.SALGRADE;
    Can i get out of this Scott cheers


Comments

  • #2
    Karoma
    Registered Users, Registered Users 2 Posts: 19,396 ✭✭✭✭Karoma


    It's intentional... What error?


  • #3
    JackieChan
    Closed Accounts Posts: 1,829 ✭✭✭JackieChan


    If you are logging on as SCOTT and are attempting to create the tables it is probably because they already exist.
    If you don't want to be logged in as scott then you must get another logon from your instructor.
    You can not do much without been connected to the database as a valid user


Advertisement