Member Avatar for Jeeva_rtp

Hi There. I am newbie. I need some helps on the below issues. Please help me!

1. How to create / delete user in Sql / Oracle?
2. How can I set privilages while create a new user?
3. How can I view all forms / tables?
4. How can I list the users already got account in Sql?
5. Which is the best web site to learn oracle (for beginners)?

After all, still I am confusing about Oracle & Sql? Could any one able to describe the difference?

Thanks in advance. Have a good day to all.

  • 2 Contributors
  • 2 Replies
  • 145 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Jeeva_rtp
Member Avatar for debasisdas

1. create user user1 identified by password1
2. grant previlags / roles to user1.
3. select * from tab.
4. select * from all_users.
5. there are many , we can do it here at daniweb.

all the above answers are for oracle database.

I am not sure you are asking about sql or sqlserver. I still don't understand why people refer sql server as sql.

Member Avatar for Jeeva_rtp

I am not sure you are asking about sql or sqlserver. I still don't understand why people refer sql server as sql.

Dear Sir

Thanks for your reply.

Actually I meant Sql Server.

Regards
Jeeva

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.