![zia.sepsis](https://www.crazyengineers.com/img/avatar.jpg)
Member • Dec 22, 2008
Member • Dec 22, 2008
Member • Dec 24, 2008
Member • Dec 24, 2008
Member • Dec 24, 2008
Member • Dec 24, 2008
Member • Dec 28, 2008
Member • Dec 28, 2008
Member • Dec 29, 2008
Member • Dec 29, 2008
i cant get you bronileshchakkardude one more option
ummmm
yah
change the privilage i didnt remember exacly but with help of which we can switch from one to other i mean to say it can work as many user n many accounts
Member • Dec 29, 2008
Member • Dec 29, 2008
Thanks matenileshchakkaractually there are commands in sql like grant and revoke.
GRANT:-
The SQL command grant allows to assign #-Link-Snipped-# and #-Link-Snipped-# to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;
grant #-Link-Snipped-# to username;
grant #-Link-Snipped-#, system_privileges_2, ..,system_privileges_n to username;
grant #-Link-Snipped-# to username #-Link-Snipped-#;
grant #-Link-Snipped-# to username;
grant #-Link-Snipped-# to username with grant option;
grant #-Link-Snipped-# to username with #-Link-Snipped-#;
The SQL command grant allows to assign #-Link-Snipped-# and #-Link-Snipped-# to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;
grant ... ANY ...
If a privilege is granted on ANY object (grant create any table to some_one), the user (or role) is given this privilege in all #-Link-Snipped-#, even in schema SYS. In order to prevent this, the initialization parameter #-Link-Snipped-# must be set to false.
with admin option
If with admin option is specified, the grantee can grant the granted privilege to someone else.
with hierarchy option
This clause only makes sense with the select privilege.
Showing granted privileges for a user
#-Link-Snipped-# allows to recursively list users, their roles and privileges.
Links
#-Link-Snipped-# (that can be granted).
REVOKE:-
It is exactly opposite to the grant.
Removes a previously granted or denied permission.
and for more detail just refer
<a href="https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm" target="_blank" rel="nofollow noopener noreferrer">SQL GRANT, REVOKE, Privileges and Roles</a>
<a href="https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm" target="_blank" rel="nofollow noopener noreferrer">SQL GRANT, REVOKE, Privileges and Roles</a>