Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5534 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the differences between stored procedure and the dynamic sql?
What are scalar functions?
Write a program to fetch first 10 records from a file?
What is replace and stuff function in sql server?
What is log ldf?
How do you size a resultset?
Define candidate key, alternate key, and composite key.
What is a rollup clause?
Write a SQL query to make a column as unique?
What is the purpose of object explorer and its features? : sql server management studio
What is spatial and temporal data?
What is public role in sql server?
How you can add messages to the nt event log from within a stored procedure?
What is deploy, process and build? : sql server analysis services, ssas
