Home » SQL & PL/SQL » SQL & PL/SQL » Login Problem
Login Problem [message #253053] Sun, 22 July 2007 00:41 Go to next message
msrafeeq
Messages: 8
Registered: July 2007
Junior Member
Dear All

I have created an user name & password to give access to my employee in the sql server. It was working okey. Last two days he is unable to login to the server. I have tried the below steps.

Alter his password thru ALTER Command - Still not able to login
Grant Permissions in particular roles - Still not able to login

What else should I have to try?
How can I view his permission privileges?

Please someone reply my as much as can ...Thanks in advance

Regards
Rafeeq
Re: Login Problem [message #253059 is a reply to message #253053] Sun, 22 July 2007 01:18 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
What error message you get? May be his password expried?

Please post the error you so that its easy for memebers to reply to your question.


Query dba_sys_privs for systeme privileges granted to user.
Query dba_tab_privs for object privileges granted to user
Query dba_role_privs for roles granted to user.

Blessings
unus

Re: Login Problem [message #253060 is a reply to message #253059] Sun, 22 July 2007 01:20 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Sorry!!!!!!

I didnt see its sql..I thoughts its oracle!!! Embarassed
Re: Login Problem [message #253061 is a reply to message #253053] Sun, 22 July 2007 01:24 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't you see this is an ORACLE forum (its name is OraFaq for ORACLE FAQ's).
Post your question in an SQL Server forum.
./fa/448/0/
Regards
Michel
Previous Topic: what is rowid and rownumber
Next Topic: How to use prepare statment?
Goto Forum:
  


Current Time: Mon Dec 05 21:32:42 CST 2016

Total time taken to generate the page: 0.08175 seconds