Answer / sqldba29

I want to give access to a new user (example "user A") same
access as another existed user for (example "User B'").

User B has access to 8 databases in one server... (Read,
write, ddl)

My question is, what are the ways to give the access
to "User A"... or we have to open each database of "user B'
has and see his/her permissions on that database and then
open the "user A" and give the permission accordingly.

If you are doing any differently please help me.

Answer / dolly rajdev

As you know what all access are provided to the existing "User B".
You can give the same access to the new user "User A".
Run the command ->
GRANT SELECT ON SCHEMA::dbo to User A
likewise u can give the below permissions ->
GRANT INSERT ON SCHEMA::dbo to User A
GRANT UPDATE ON SCHEMA::dbo to User A
GRANT DELETE ON SCHEMA::dbo to User A
All u need to do is just select the Database from the drop-down list in the SQL Server Manangement Studio and run the above scripts once.
If u want the same permission to be given to the same user in 8 databases the select all the databases one by one from the drop-down in SQL Server and run the same scripts.

Answer / kiran

Always prefer giving permissions to a group.mark up the
permissions of a onto a group and then all u need to do is
add the new user to that group.this is the most efficient
way that new users can be added with same permissions as
that assigned to previous users.

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

Does sql server use t sql?

0 Answers  

---

What is a transactions?

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

How is a full-text index updated?

0 Answers  

---

What is sql server profiler trace data file?

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

What is an active database?

0 Answers   HCL,

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---