0

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
4
Views
8 Years
Discussion Span
Last Post by Jeeva_rtp
0

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.

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.